php while loop + where

Question

list table

id
name
illness
recipe

directions

$illness = 'Highblood';
$list = mysql_query("SELECT * FROM list ",$con);
while($row=mysql_fetch_array($list, MYSQL_ASSOC)){
 $test[] = $row['recipe'];
 $test2[] = $row['directions'];
 }

I want to only get the rows

$row['recipe'];
$row['directions'];

if the value of illness column is equals to highblood. how do I do this?

This isn't an answer to your question, but you should not be using mysql_* today. Consider PDO. stackoverflow.com/questions/16859477/… — Tom Mettam
– Tom Mettam, Commented Apr 18, 2016 at 15:46

poudigne · Accepted Answer · 2016-04-18 15:37:47Z

2

I suggest to make some search on google to learn MySQL if you can't do basic query like this.

mysql_query("SELECT * FROM list WHERE illness = '".$illness."'",$con);

answered Apr 18, 2016 at 15:37

poudigne

1,7664 gold badges18 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

sad beginner Over a year ago

did this at first but It has the same effects with $list = mysql_query("SELECT * FROM list ",$con); because i still get the rows of recipe of other illness like Anemia

poudigne Over a year ago

@sadbeginner then you did something wrong. Read this : techonthenet.com/mysql/where.php

Levan Abashidze · Accepted Answer · 2016-04-18 15:38:13Z

2

Select only required rows.

$list = mysql_query("SELECT recipe,directions FROM list WHERE illness='Highblood'",$con);
while($row=mysql_fetch_array($list, MYSQL_ASSOC)){
  $test[] = $row['recipe'];
  $test2[] = $row['directions'];
}

answered Apr 18, 2016 at 15:38

Levan Abashidze

1106 bronze badges

Collectives™ on Stack Overflow

php while loop + where

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related