Mysql Hell!!!!

k994519

Hi guys,

Any help would be much appricated.......

And Yes I am a newbie

$query="SELECT users ( this is a table) FROM guestbook2k( the database) WHERE name(column in table users) =".$_POST["name"] ;

I think the syntax is wrong however I am not sure

any help would be great....

yelvington

Yes, it's wrong.

First, connect.
http://us3.php.net/mysql_connect

Then, select the database.
http://us3.php.net/mysql_select_db

Then construct your query like this:

$query = "SELECT * FROM users WHERE name=$POST['name']";

and pass it to mysql using mysql_query().
It returns a resource; you must loop from it with one of the mysql_fetch family of functions (your choice).

The database is NOT named in the query.
"SELECT *" says "get me all of the columns in this table" and the WHERE clause is obvious. Watch those quotation marks.

Drakla

Just a small note, but mysql_select_db is deprecated, so start using mysql_query with "USE dbName" as the query.

yelvington

I don't see anything in the manual that deprecates mysql_select_db(). The manual page says:

For downward compatibility mysql_selectdb() can also be used. This is deprecated however.

Note that the reference is to an older form of notation without an underscore between "select" and "db."

k994519

thanks for all ur help.....

its working now...

Drakla

Hi again.

It doesn't say in the manual about mysql_select_db being deprecated, but if you run php with all errors and notices on it throws up in your face a notice about its deprecation, and tells you to do the query("USE dbName") thing.