help please!!!!!!!!!!!!!!!!!!!!!!

[rocket]

i dont know what is wrong with this code i keep geting a T_CONSTANT_ENCAPSED_STRING err.

<?
$query = "SELECT * FROM address WHERE state LIKE "^i"";
$result = mysql_query($query)
or die("Query failed");

/* fetch rows in reverse order */
for ($i = mysql_num_rows($result) - 1; $i >= 0; $i--) {
    if (!mysql_data_seek($result, $i)) {
        echo "Cannot seek to row $i\n";
        continue;
    }

    if(!($row1 = mysql_fetch_object($result)))
        continue;

echo "$row1->address_id<hr><br><br />\n";}

mysql_free_result($result);
?>

[[deleted]]

Well, how do you expect PHP to know what you mean by all the quotes in this:

$query = "SELECT * FROM address WHERE state LIKE "^i"";

try using single-quotes in SQL:

$query = "SELECT * FROM address WHERE state LIKE '^i'";

Also note that 'LIKE' without wildcards is the same as '=', it will not search for substrings, only for exact matches.

[rocket]

THANKS