[SOLVED] MySQL Varible Select From Help

[maxudaskin]

Is this correct?

 

mysql_fetch_array('SELECT * FROM `applications` WHERE `id` = ' . $id)

 

I get an error:

mysql_fetch_array(): supplied argument is not a valid MySQL result resource

[JasonLewis]

to run the mysql_fetch_array you need a mysql resource. to get this you must first run a query:

 

mysql_fetch_array('SELECT * FROM `applications` WHERE `id` = ' . $id)

 

should be:

 

$query = mysql_qurey("SELECT * FROM `applications` WHERE `id`='{$id}'");
$array = mysql_fetch_array($query);

 

hope it helps.

[maxudaskin]

to run the mysql_fetch_array you need a mysql resource. to get this you must first run a query:

 

mysql_fetch_array('SELECT * FROM `applications` WHERE `id` = ' . $id)

 

should be:

 

$query = mysql_qurey("SELECT * FROM `applications` WHERE `id`='{$id}'");
$array = mysql_fetch_array($query);

 

hope it helps.

 

Thanks!!