what am I doing wrong, check my code

Anon

Im a begineer to php. I have managed to connect to my database, insert data and display data to a webpage. I want to be able to update my data. What I am trying to do first thou is get the data from my database and display it in 2 text boxes via a input box on an html page. What am I doing wrong with the code. You may laugh at it, but I am trying. It would be a great help if someone could modify the code for me.

Here is the code:

TESTFORM.HTML

SEARCH.PHP
<?php
if($submit)
{
$db = mysql_connect(\\"localhost\\", \\"username\\", \\"password\\");
mysql_select_db(\\"db_name\\",$db);
$result = mysql_query(\\"SELECT * FROM greatbritain WHERE name=\\'$search\\'\\",$db);
if ($myrow = mysql_fetch_array($result))
{
echo \\"<INPUT TYPE=TEXT NAME=name VALUE=<? echo $name ?>\\";
echo \\"<INPUT TYPE=TEXT NAME=address VALUE=<? echo $address ?>\\";

}
}

?>

thefury

dumb ass phpbuilder forum must of f'ed up the quotes.
I hope your not putting / infront of the quotes in functions.

if ($myrow = mysql_fetch_array($result))
should be
while ($myrow = mysql_fetch_array($result))

On here
<? echo $name ?>
Should be
<? echo $myrow[name];?>

Anon

No, There is no way I put slashes in my code, PHP Builder put them in there for some reason.
Thanks for the help.

Anon

<?php
if($submit)
{
$db = mysql_connect(\\"localhost\\", \\"username\\", \\"password\\");
mysql_select_db(\\"db_name\\",$db);
$result = mysql_query(\\"SELECT * FROM greatbritain WHERE name=\\'$search\\'\\",$db);
if ($myrow = mysql_fetch_array($result))
{
echo \\"<INPUT TYPE=TEXT NAME=name VALUE=<? echo $name ?>\\";
echo \\"<INPUT TYPE=TEXT NAME=address VALUE=<? echo $address ?>\\";

}
}
?>

funny how php builder works? they use addslashes() function going into the database, but forgot to use stripslashes() coming out...hmmm

Anyways, about your problem...

You forgot a line and goofed up the $result line

it should be

$sql ="SELECT * FROM greatbritian WHERE name = \"$search\"";
$result = mysql_query($sql, $db);

hope that helps