june_c21 Posted November 16, 2007 Share Posted November 16, 2007 why when i wrote "SELECT staff_no FROM report" it didn't come out all the data in the database? Link to comment https://forums.phpfreaks.com/topic/77594-select-problem/ Share on other sites More sharing options...
Lumio Posted November 16, 2007 Share Posted November 16, 2007 Do you mean, that not every line comes out or do you mean that not every column comes out? Link to comment https://forums.phpfreaks.com/topic/77594-select-problem/#findComment-392749 Share on other sites More sharing options...
~n[EO]n~ Posted November 16, 2007 Share Posted November 16, 2007 Where did you try that ? It should fetch all the staff_no from table report. Link to comment https://forums.phpfreaks.com/topic/77594-select-problem/#findComment-392751 Share on other sites More sharing options...
aschk Posted November 16, 2007 Share Posted November 16, 2007 It's not going to 1) Give you all the columns in that table because you only selected one (staff_no) 2) Give you ALL the data in the database because you only selected one table It will 1) Give you a staff_no for EVERY row in the table "report". Link to comment https://forums.phpfreaks.com/topic/77594-select-problem/#findComment-392757 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.