search.php problems

[silky]

please go to www.yourhouston.net and click on a letter of the alphabet to get a business catagory and see the php error message that comes up - what is this?

Ive changed servers and mysql is all screwed up!

[missing-score]

That means you have a parse error, no problem with mysql from what I can see.

what is your code?

[silky]

<? mysql_connect, ('localhost', 'yourhouston_net', 'silky77', ); $result = mysql_query("Select * from businesses where username='$username' and password='$password'"); @extract(mysql_fetch_assoc($result)); ?>

[silky]

it's not picking up on the businesses that are in the database, nor is it letting you edit your listing www.yourhouston.net and in the fileds to the immediate left Edit Listing, put in silky silky which is the un and pw for my listing and its supposed to come back with the whole document with the fields filled in for me to edit and resubmit but it goes to some php page. Maybe Im putting the code in the wrong documents?

[missing-score]

<?

mysql_connect('localhost', 'yourhouston_net', '******'); // There was commas, I took em out. PS. You may wish to remove your db password if that is it :D

$result = mysql_query("SELECT * FROM `businesses` WHERE username='$username' and password='$password'"); // Uppercased, ensure it is all in right case (for column names);

extract(mysql_fetch_assoc($result)); // No @ symbol when you are getting an error!

?>