Re: SQL Warning

Hey... Ok Firs Mike.. Yes I have been "fixing" some of her scripts and saw she used this too.. Unbelievably I also so this point about the string in the string without concat op's but incredibly it works.. Now back to reason why it don't work.. Okay Jenny.. Hi again :) Next.. Do you have anything actually IN your table ({$config["prefix"]}_users) ?? If so does the username in it match {$session["uid"]} ?? If it doesn't and mysql_query returns a error cos a) table don't exist or b) some other sql error such as column name wrong etc.. Then mysql_fetch_array will cough up error.. This happened when I setup your scripts on my box.. And whenever I setup any scripts in which I don't yet have any records matching the query so mysql_fetch_array goes nuts.. Ok.. Hope it helped.. ::::::::::::::::::::::::::::::::::::::::::: : Julien Bonastre [The-Spectrum.org CEO] : A.K.A. The_RadiX : the_radix@hotkey.net.au : ABN: 64 235 749 494 : QUT Student :: 04475739 ::::::::::::::::::::::::::::::::::::::::::: ----- Original Message ----- From: "Ford, Mike [LSS]" <M.Ford@lmu.ac.uk> To: "'Jennifer Downey'" <jendowney@attbi.com>; <php-general@lists.php.net> Sent: Wednesday, April 24, 2002 10:05 PM Subject: RE: [PHP] SQL Warning > > -----Original Message----- > > From: Jennifer Downey [mailto:jendowney@attbi.com] > > Sent: 24 April 2002 04:46 > > > > Would you please direct your attention to this URL > > > > http://testphp.netfirms.com/code1.html > > > > Look at the bottom where the big orange commented syntax is > > and explain what > > is going on there? > > ======================================== > $query = "SELECT name FROM {$config["prefix"]}_users WHERE uid={$session["uid"]}"; > > $ret = mysql_query($query); > > > > // this is line 14 > while($row = mysql_fetch_array($ret)) > . > . > . > // this is the problem area. It is giving me this sql warning Warning: Supplied argument is not a valid MySQL result resource in /home/public_html/sortitems.php on line 14 look at top for line 14 why is it > > // looking at line 14 I am not asking for any of that information? > ======================================== > > No idea why the error message is so far down the page, but it is certainly referring to line 14 -- it is telling you that the $ret you are supplying to mysql_fetch_array is invalid. Why? Because the mysql_query failed, and so $ret was not assigned valid result resource. This is why you should ALWAYS check the return value of a mysql_query call before trying to fetch its results. > > Now, why is the query failing? Well, let's take a look at this line: > > $query = "SELECT name FROM {$config["prefix"]}_users WHERE uid={$session["uid"]}"; > > The stuff to the right of the "=" consists of: > > (1) the string "SELECT name FROM {$config[" > (2) the constant named prefix (which, I guess, doesn't exist) > (3) the string "]}_users WHERE uid={$session[" > (4) the constant named uid (ditto!) > (5) the string "]}" > > with NO concatenation operators in between. > > This line ought to generate multiple warnings and notices -- you must have error_reporting set to suppress all these useful messages, so I suggest you change it to something more useful forthwith (such as E_ALL, or at least E_ALL ^ E_NOTICE). > > So, the final solution to your problem would be either of the following: > > $query = "SELECT name FROM {$config[\"prefix\"]}_users WHERE uid={$session[\"uid\"]}"; > > $query = "SELECT name FROM {$config['prefix']}_users WHERE uid={$session['uid']}"; > > Hope this helps. > > Cheers! > > Mike > > --------------------------------------------------------------------- > Mike Ford, Electronic Information Services Adviser, > Learning Support Services, Learning & Information Services, > JG125, James Graham Building, Leeds Metropolitan University, > Beckett Park, LEEDS, LS6 3QS, United Kingdom > Email: m.ford@lmu.ac.uk > Tel: +44 113 283 2600 extn 4730 Fax: +44 113 283 3211 > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >