help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

rocket

How do i make this script pull out the whole row and not just one field?

<?
if ($REQUEST_METHOD=="POST") {

    # double-up apostrophes 

    		$textfield = str_replace("'","''",$textfield);

$query = "SELECT * FROM name WHERE namefirst LIKE '$textfield%'";
$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->namefirst <br />\n";}

mysql_free_result($result); }
?>

raymie

ok.

Firstly I am sure that somewhere in these forums you are told not to title posts in a non descriptive manner like you have done. Very bad form and less likely to get you any advice.

Secondly you are also supposed to put code in the code tags supplied when you have to include it on posts, that way it is actually readable.

Finally..

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

is the line you want to look at, I assume that 'state' is one of the fields on the table.