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 Link to comment https://forums.phpfreaks.com/topic/44912-simple-question/ 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; Link to comment https://forums.phpfreaks.com/topic/44912-simple-question/#findComment-218121 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 Link to comment https://forums.phpfreaks.com/topic/44912-simple-question/#findComment-218139 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.