|
|
Posted by Matthew White on 09/03/07 13:47
"Captain Paralytic" <paul_lautman@yahoo.com> wrote in message
news:1188822951.234785.7490@19g2000hsx.googlegroups.com...
> 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!
The query returns a mysqli_result object, then stalls on the
mysqli_fetch_array. This results in a blank page. If I removed the <, the
query returns the same object, and returns an array after
mysqli_fetch_array. That's the only ouput.
Navigation:
[Reply to this message]
|