MySQL Problem

[Anon]

2nd problem of the day!!

Can any one tell me why the following code gives the error Warning: Supplied argument is not a valid MySQL result resource in C:\Inetpub\wwwroot\new-web\internet\main\hosting\index.php on line 143? I have put line 143 in (")quotes for you to look at.

db_connect();

$query = "SELECT package, FROM hosting WHERE id = $host_package";

$result = mysql_query($query);
if(!$result) echo "Error fetching data from database";

"$query_data = mysql_fetch_row($result);" <--HERE???

$package_name = $query_data[0];

print ("<table border='0' width='100%'>\n");
print ("<tr>\n");
print ("<td><font class='bodyfont' size='2'>You have chosen to purchase our <b>$package_name</b> hosting package. Please complete the following form to confirm your order.</font></td></tr>\n");
print ("</table>\n");

[leatherback]

Try: if (!$result) {...}

and perhaps the comma after select package
And perhaps the quote around line 143?

J.

[fitzbean]

You have a comma after SELECT package in your SQL call, thus producing the error when you try to refer to the result. 🙂

[Anon]

Arrghh!!

Thanks guys...been staring at the code all day...you know what it's like!

[leatherback]

Cheers!

[fitzbean]

I sure do. Whenever you get one of those invalid result..etc..etc you can bet that it's in your mtSQL statement.

[fitzbean]

Hey Mike, I saw your other problem about printing all fields into a table from a DB table. Now, I know you might have solved the problem already, but consider this method, which basically does all the work for you, and requires no changes to the code if you add more fields to the Db table etc..

$r = mysql_query($sql);

$numberoffields = mysql_num_fields($r);
echo "<TABLE>";
$i = 1;
while ($rr = mysql_fetch_array($r))
{
echo "<TR>";
for ($ii=0; $ii < $numberoffields; $ii++)
{ if ($i == 1) { echo "<TD><BOLD>" . mysql_field_name($r, ii) . "</BOLD></TD>"; } else { echo "<TD>${rr[$ii]}</TD>"; } }
echo "</TR>";
$i++;
}

That's it. It'll print all the fields in the DB, based on the SELECT of course, with the title of the fields printed once at the top of the page.