You are here: Re: Error with < in SQL « PHP SQL « IT news, forums, messages
Re: Error with < in SQL

Posted by Matthew White on 09/03/07 12:10

"Captain Paralytic" <paul_lautman@yahoo.com> wrote in message
news:1188810171.687472.262900@g4g2000hsf.googlegroups.com...
> On 2 Sep, 21:42, "Matthew White" <mgw...@msn.com> wrote:
>> I have started using the new mysql_* extensions. Here is the code I am
>> trying to run:
>> $temp2 = "SELECT * FROM assignments2 WHERE daydue < '247' &&
>> progress !=
>> '100'";
>> $temp2 = mysqli_query($mysqli,$temp2) or
>> die(mysqli_error($mysqli));
>> $temp2 = mysqli_fetch_array($temp2) or
>> die(mysqli_error($mysqli));
>>
>> This query doesn't work (though it throws no errors). Only when I change
>> the "<" to "<=" does the script work. Why doesn't the less than operator
>> work?
>
> "This query doesn't work",
> Very helpful this, very discriptive!
> What precisely doesn't work about it? Do you just get no data output?
> If so, please post some of the output from when it does "work".
>

When it fails, it just returns a blank page, disregarding all other code
below it. If it completes, it will display the names and dates of all
assignments that are overdue.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация