Hi
I'm trying run the following SQL statement against a MySQL database.
No I know the SQL is correct, but what I can't do is display the result. I think this is largely due to my extreme lack of PHP knowledge. I can run and execute the SQL, but can't display the result. I'm using the code below. Could somebody explain why it isn't working and give me an example of hoiw it should be written? Better still, does anyone know of any comprehensive PHP/MySQL tutorials on the web they could point me to please?
<?
$rs = mysql_query("SELECT COUNT(P_ID) FROM PACKAGES") or die ("Query Failed");
$fv = $rs->Fields("P_ID");
print $fv->value;
?>
Thanks,
Darren.