Go Back   Novahq.net Forum > phphq.Net > phphq.Net Forums
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 06-01-2005, 05:51 AM
Stu is offline Stu
Resident Member

Join Date: Aug 2003
Posts: 3,319

Mysql SELECT query.

Hey all, I'm using a mysql_query(); statement, with the SELECT statement to get my results, but i was woundering what I put after the SELECT Command, to get rows that have a certain field in, for example:
-------------------------
id ¦ name ¦ type ¦ price ¦
-------------------------
1 ¦Chicken¦ Meal ¦ £12.00 ¦
2 ¦Pasta ¦Meal ¦ £7.00
3 ¦Coke ¦Drink¦ £1.00
4 ¦Beer ¦Drink¦ £2.00
5 ¦Pie ¦Pudding¦ £3.00
-----------------------------
How Would i get it to display all the Meals? Say it would SELECT - then something here to do with Meal? I cant remember, can someone help me here please :?
-Tecoma2
Reply With Quote
  #2  
Old 06-01-2005, 03:08 PM
PHP-Largo
Unregistered

Posts: n/a

"SELECT meals FROM db"; ... or do "SELECT * FROM db"; while($row = mysql_fetch_array($meal)){
echo'yadayaaya ''.$row['meal'].'';
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Query strings... BeBop Web design and Programming 0 02-01-2006 08:59 PM
Query Stoint Sigs and Graphics 7 06-13-2005 07:52 PM
Query Optimization BeBop Web design and Programming 5 01-14-2005 06:01 PM
Select more than 1 game played... Trade Feedback / Novahq.net Support 2 05-20-2004 02:10 AM
Can't select anything in Novaworld Homer J Delta Force 1 01-13-2003 09:09 AM


All times are GMT -5. The time now is 08:18 AM.




Powered by vBulletin®