specific query problem

[Anon]

I am having a problem with a specific query within PHP (the query will execute successfully using a sql client). The code listed below generates the following error:

Parse error: parse error, unexpected T_LNUMBER in %\www\share\index.php on line 41

If I replace the query with the following one listed below it will execute successfully:

$result = mysql_query("select * from syslogd limit 100");

Please help .....

// CODE **************

<?
$result = mysql_query("select * FROM syslogd WHERE MSGTIME >= DATE_SUB(NOW(),INTERVAL 10 MINUTE) and (MSGDATE="2002-07-10") limit 100");

printf("<TABLE BORDER=1>\n");
printf("<TR><TD>name1</TD><TD>name2</TD>\n");
printf("<TD>name3</TD><TD>name4</TD>\n");
printf("<TD>name5</TD></TR>\n");

while ($myrow = mysql_fetch_array($result))
{
printf("<TR><TD>%s</TD><TD>%s</TD><TD>%s</TD><TD>%s</TD><TD>%s</TD></TR>\n", $myrow[0], $myrow[1], $myrow[2], $myrow[3], $myrow[4]);
}

printf("</TABLE>\n");
?>

[Anon]

mysql_fetch_array($result) will return an array with MySQL variables name as indexes...
Suppose you have a MySQL variable named "name1", you'll get it with $myrow["name1"]

[Anon]

$result = mysql_query("select * FROM syslogd WHERE MSGTIME >= DATE_SUB(NOW(),INTERVAL 10 MINUTE) and (MSGDATE='2002-07-10') limit 100");

You shouldn't use limit without order by.

[theslinky]

Yep, just what H.L. said: check your arrays. if you want to use the 0,1,2 indexes, then you must use MYSQL_BOTH:

QUote from teh manual:

Example 4. mysql_fetch_array with MYSQL_BOTH

<?php
mysql_connect("localhost", "mysql_user", "mysql_password") or
die("could not connect");
mysql_select_db("mydb");

$result = mysql_query("SELECT id, name FROM mytable");

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
    printf ("ID: %s  Name: %s", $row[0], $row["name"]);
}

mysql_free_result($result);

?>

[Anon]

I made the array change as listed below, but it still errors out with the same message and it sill works when I use a simple query.

Any ideas? Thanks...

while ($myrow = mysql_fetch_array($result, MYSQL_BOTH))
{
printf("<TR><TD>%s</TD><TD>%s</TD><TD>%s</TD><TD>%s</TD><TD>%s</TD></TR>\n", $myrow[0], $myrow[1], $myrow[2], $myrow[3], $myrow[4]);
}

[theslinky]

Hi,

You have an error in line 41. Would you be able to identify this line and print this line (and others near it) with the line #s?

Also, what version of PHP are you using? Not that it should matter, but just in case any of us are aware of bugs with that version :-)

-sridhar

[rrijnders]

Change:
<font color=blue>
$result = mysql_query("select * FROM syslogd WHERE MSGTIME >= DATE_SUB(NOW(),INTERVAL 10 MINUTE) and (MSGDATE="2002-07-10") limit 100"); </font>

To:
<font color=blue>
$result = mysql_query("select * FROM syslogd WHERE MSGTIME >= DATE_SUB(NOW(),INTERVAL 10 MINUTE) and (</font><font color=red>MSGDATE='2002-07-10'</font><font color=blue>) limit 100"); </font>

Note the double quotes changed to single quotes

The error is caused because your use of double quotes in the middle of the query causes the PHP parser to think that you ended the string. It then attempts to pass the rest of the query string as additional parms to the mysql_query() function which are determined to be invalid.

-- Rich

[Anon]

Thanks, that actually seemed to resolve the problem, but one last problem remains as a result of the fix. It looks like the query goes thru but nothing is displayed on the browser (output) but again, using the simple query - the results are successfully posted to the browser in a table format?

[Anon]

Hey Sridhar, Richard's suggestion resolved the problem, but one last problem now remains as a result of the fix. It looks like the query goes thru but nothing is displayed on the browser (output) but again, using the simple query - the results are successfully posted to the browser in a table format?

[rrijnders]

If the sample script you posted is accurate, you should at least get the table headers; they are output unconditionally.

Do you see the table tags when you "view source" on the resulting page?