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? Quote 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? Quote 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. Quote 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". Quote Link to comment https://forums.phpfreaks.com/topic/77594-select-problem/#findComment-392757 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.