DangerM0use Posted March 30, 2007 Share Posted March 30, 2007 Hi, this is a really simple question and one I should know the answer to. I am doing a tutorial task at uni where I have to get one row of data from every field in the table using asp.net The MySql part I currently have is; "SELECT * FROM Film showing" but as you know this is getting everything from the film showing table. What do I change to get what I want?? Cheers Quote Link to comment Share on other sites More sharing options...
obsidian Posted March 30, 2007 Share Posted March 30, 2007 If you are wanting to get all columns from exactly one row, you could simply attach a LIMIT 1 to the end of your query: SELECT * FROM Film_showing LIMIT 1; Quote Link to comment Share on other sites More sharing options...
DangerM0use Posted March 30, 2007 Author Share Posted March 30, 2007 Yer I did try that but got an error with the aspx part of things. Oh well, will have to go digging further Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.