#1
|
||
|
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 |
#2
|
||
|
"SELECT meals FROM db"; ... or do "SELECT * FROM db"; while($row = mysql_fetch_array($meal)){
echo'yadayaaya ''.$row['meal'].''; |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|
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 |