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

Posted by Captain Paralytic on 09/03/07 12:35

On 3 Sep, 13:10, "Matthew White" <mgw...@msn.com> wrote:
> "Captain Paralytic" <paul_laut...@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.- Hide quoted text -
>
> - Show quoted text -

It can't return a blank page. It is a query. It returns a data
resourse.

Now I asked you to "please post some of the output from when it does
"work"."

Instead you told me about the data that the program displays on a web
page (I assume).

Now can you please post some of the output FROM THE QUERY!

 

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

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