One Query Executed successfully, while the other two didn't

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
matt1019
Forum Contributor
Posts: 172
Joined: Thu Jul 06, 2006 6:41 pm

One Query Executed successfully, while the other two didn't

Post by matt1019 »

Hi guys,


Problem sovled guys

solution to the problem was:

I was missing ' (apostrophe) in the following line:

".$dataxyz['user_id']."

this was finally noticed, thanks to the post by mysql guru astions (look for post below this one)

also, i did this at the top of my php page (after the <?php tag):

Code: Select all

error_reporting(E_ALL);
This is what helped me find out what my error was. here's what the page had to say when I had ".$dataxyz[user_id]."
Notice: Use of undefined constant user_id - assumed 'user_id' in $$$\DIR NAME\###\###.php on line 233
Thanks,

-Matt
Last edited by matt1019 on Tue Jul 18, 2006 10:36 am, edited 3 times in total.
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Post by Benjamin »

Try..

Code: Select all

echo mysql_error();
That should make it easier to find the problem right :)
Post Reply