Posted by John Moore on 11/02/05 21:26

On Wed, 02 Nov 2005 19:09:25 GMT, in comp.lang.php Oli Filth
<catch@olifilth.co.uk> wrote:


>
>Without seeing the function, it's difficult to say!
>
>Have you tried getting the function to echo the query string that it
>creates, and comparing that to what you expect?

Like I said, I got rid of the function. Now I'm just dealing with this
snippet of code which won't execute:

mysql_query("UPDATE about SET category_id=63 WHERE about_id=5") or
trigger_error(mysql_error(), E_USER_ERROR);

I'm running it exactly like that.

I also tried it like this:

$update = mysql_query("UPDATE about SET category_id=63 WHERE
about_id=5") or trigger_error(mysql_error(), E_USER_ERROR);
if (!$update) {
echo 'Error: ' . mysql_error();
}
echo '<hr>Info: ';
mysql_info($update);
echo '<hr>';

mysql_info returns a warning:

Warning: mysql_info() expects parameter 1 to be resource, boolean
given in c:\Path\to\script.php on line 384

Thanks,

J Moore

• Next in forum: Re: How to debug PHP's mysql_query() function?
• Prev in forum: Re: How to debug PHP's mysql_query() function?
• Thread view: Re: How to debug PHP's mysql_query() function?

[Reply to this message]