deadboy Posted April 23, 2008 Share Posted April 23, 2008 Good Dayz guyz hope ol iz well... i gotta a problem that is really buuging ma brain, nway hope you gurus will help me solve.. ----> problem i need to query ma database using php and the problem iz --- i got some data as shown below: paper_id Semester Year BIT339 1 2 BIT445 1 2 ]BSC778 1 2 my project is designin an e-learning tool so i need to query and display all paper_id which are in semester 1 and year 2 Plzzzzzzzzzzzzzzzzzzzzzzzzzzzz HELP Link to comment https://forums.phpfreaks.com/topic/102462-php-mysql/ Share on other sites More sharing options...
dtjester Posted April 23, 2008 Share Posted April 23, 2008 Try this: SELECT * FROM your table name WHERE `Semester`= '1' AND `Year` = '2' Link to comment https://forums.phpfreaks.com/topic/102462-php-mysql/#findComment-524700 Share on other sites More sharing options...
dtjester Posted April 23, 2008 Share Posted April 23, 2008 You may need to play around with the quotes, I'm not 100% sure that they are correct Link to comment https://forums.phpfreaks.com/topic/102462-php-mysql/#findComment-524701 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.