FUDforum: comp.lang.php » You have an error in your SQL syntax;

Home » Imported messages » comp.lang.php » You have an error in your SQL syntax;

Show: Today's Messages :: Polls :: Message Navigator

Re: You have an error in your SQL syntax; [message #174131 is a reply to message #174129]

Sun, 22 May 2011 20:21

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

On 5/22/2011 4:11 PM, Co wrote:
> On 22 mei, 19:11, Luuk<L...@invalid.lan> wrote:
>> On 22-05-2011 16:01, Co wrote:
>>
>>> Hi all,
>>
>>> I run a query based on the input in a listbox.
>>> The query looks for users from a certain country.
>>> When no users are from the chosen country I get a error message.
>>> Is there no way to check if there are records in the query before
>>> trying to output
>>> so we only get a message saying: No records for this search.... or
>>> something like it.
>>
>>> Regards
>>> Marco
>>
>> I hope you know that there is a great MANUAL online at:http://www.php.net
>>
>> It has this great info:http://php.net/manual/en/function.mysql-num-rows.php
>>
>> --
>> Luuk
>
> Thanks Luuk,
> I didn't know.
> Anyways I tried an example from the page:
>
> $num_rows = mysql_num_rows($sql2);
> if($num_rows<> 0) {
> while($row = mysql_fetch_array($sql2)) { ......
>
> else {
> print ("<p>No records for this search were found.</p>");
> }
>
> But I still get the error line saying:
> Warning: mysql_num_rows(): supplied argument is not a valid MySQL
> result resource
>
> Marco

It means there was a problem with your SQL statement.

You need to check the results of mysql_query(), and if it is false,
determine why the SQL statement was in error.

You should ALWAYS check the return value of mysql_query() to ensure
worked correctly.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================

Report message to a moderator

[Message index]

		You have an error in your SQL syntax; By: Co on Sun, 22 May 2011 14:01
		Re: You have an error in your SQL syntax; By: Luuk on Sun, 22 May 2011 17:11
		Re: You have an error in your SQL syntax; By: Co on Sun, 22 May 2011 20:11
		Re: You have an error in your SQL syntax; By: The Natural Philosoph on Sun, 22 May 2011 20:21
		Re: You have an error in your SQL syntax; By: Jerry Stuckle on Sun, 22 May 2011 20:21
		Re: You have an error in your SQL syntax; By: Luuk on Sun, 22 May 2011 20:35
		Re: You have an error in your SQL syntax; By: Co on Sun, 22 May 2011 20:56
		Re: You have an error in your SQL syntax; By: Jerry Stuckle on Sun, 22 May 2011 21:16
		Re: You have an error in your SQL syntax; By: Co on Sun, 22 May 2011 21:22

Previous Topic:	Detecting Redirected Output
Next Topic:	Stats comp.lang.php (last 7 days)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 05:03:03 GMT 2024

Total time taken to generate the page: 0.04500 seconds