aquatsr Posted September 5, 2006 Share Posted September 5, 2006 OK. So I have a database with a table with book titles and authors. Something like this: CREATE TABLE books (book_id INT NOT NULL AUTO_INCREMENT,title VARCHAR(150),author VARCHAR(150),sample_text TEXT,PRIMARY KEY (book_id)); I want to get the sample text based upon what title and author the user chooses. I'm not sure how to do that though, any help?Oh yes, I need to display this in a webpage using php. Link to comment Share on other sites More sharing options...
skym Posted September 6, 2006 Share Posted September 6, 2006 SELECT * FROM books WHERE title='what' AND author='who'http://dev.mysql.com/doc/refman/5.1/en/select.html Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now