[SOLVED] mysql_fetch_array(): supplied argument is not a valid MySQL result....

[chris_2001]

I have been looking at it for about 20mins and I must be missing something because I can't see what is wrong with it :/ Anyone know why the query is failing?

 

mysql_fetch_array(): supplied argument is not a valid MySQL result resource in test.php on line 12

 

<?php
include "config.php";

mysql_connect("$host", "$username", "$password");
mysql_select_db("$db_name");


$query = "SELECT OrderNum FROM ordernum";
$result = mysql_query($query);


$row = mysql_fetch_array($query, MYSQL_ASSOC);
$OrderNum = "row['OrderNum']";


?>

[lemmin]

$row = mysql_fetch_array($result, MYSQL_ASSOC);

[DarkWater]

To elaborate:

The query wasn't failing, you were just using the physical query string as opposed to the result set.

[chris_2001]

Thx ahaha    i am kind of stupid today i guess  :-\

[.josh]

btw, doing

$row = mysql_fetch_array($result, MYSQL_ASSOC);

 

is the exact same as doing

 

$row = mysql_fetch_assoc($result);