How do I use MYSQL commands in PHP

Paragon

How do I use MySQL commands in PHP? like

SELECT * FROM Members

Thanks

dalecosp

I can tell you, but the PHP Manual can do much better than I...

PHP has an entire set of MySQL functions --- you'll want to learn several of them. See also the newbies forum FAQ, where planetsim made a pretty good exposition, down around #4 or #5.

Now to the ?? at hand:

$query="select * from members where username='$somevar'";

$result=mysql_query($query) or die("couldn't do SQL thang...");

$result=mysql_fetch_array($result);

// $result is now an array containing all selected data

Paragon

SELECT MEMBERS

Its a table in my MYSQL DB.

Paragon

What if I want to make a user signup.php file. I have a varible at the top like.

$loginname = $_POST['loginName']

or do I just make it like this?

$loginname = loginName

loginName is mysql column

I think I kinda get it. What I dont get is what to make it =

I know I should use POST on the form input box.

could I use something like this as the Initital vaule. [loginName]

Im just trying to start out I made a upload script just trying to make a memebers system to go with it.

Thanks

superwormy

A search on Google for PHP MySQL tutorials turns up 621,000 results:
http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=PHP+mysql+tutorials

A search on Google for PHP MySQL User Login tutorial turns up 50,200 results:
http://www.google.com/search?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=PHP+mysql+user+login+tutorials

By the looks of it, you'd learn a great deal from any one of them. Try searching the forums as well, you'll find numerous topics like this.

Oh, and did I mention read the Manual!?! ( http://www.php.net/manual/en/ )