[PHP] mysql

2002-04-10 Thread Mason Batley
Hi guys, I've been looking on the net and the php docs for a simple mysql query solution, can someone please let me know the best way to get the values of a query that only returns 1 record? All the select query examples on the net are examples of multiple records being returned, and therefor, t

[PHP] mysql

2002-01-30 Thread Mason Batley
bleh, its not working I'll take another approach, If I use a count(*) query, it will return 1 record with a value, possibly 0. what command can I use to grab it from $result ?

[PHP] mysql

2002-01-30 Thread Mason Batley
G'day I keep getting an error message of :Warning: Supplied argument is not a valid MySQL result resource in /var/www/html/RageProject/StripPlayList.php on line 100 Rows: $link = mysql_connect("127.0.0.1", "rage", "rage"); mysql_select_db("rage"); $query = "Select id from songs