connect to database table

[josh48202]

i need help connecting to 1 specific database table

 

im already connected to mysql using this code

 

<?php

mysql_connect("localhost", "XXXXX", "YYYYY") or die(mysql_error());

echo "Connected to MySQL<br />";

mysql_select_db("VVVVV") or die(mysql_error());

echo "Connected to Database";

?>

 

what else do i need to connect to the table?

[Hypnos]

This is the standard way of getting a result set:

mysql_connect("localhost", "XXXXX", "YYYYY");
mysql_select_db("VVVVV");
$result = mysql_query("SELECT * FROM tablename");

while($row = mysql_fetch_assoc($result)) {

print $row['columnname'];
print $row['columnname2'];

}

 

That's all that can be explained in a normal post. For more information, you really have to do research on how MySQL queries are formed and such.

 

http://www.sqlzoo.net/

 

And there are a billion tutorials on MySQL and PHP.

[Orio]

You can't "connect" to a table. Now that you are connected to a mysql database, you can run various queries on it- including selecting data from a table, inserting or updating the data in the tables, deleting tables and much more. You should read some php+mysql tutorials the will teach you how to do all of the things that I've mentioned above. Just start reading (links).

 

Orio.

[josh48202]

i wanted to connect to the table that stores all the login information for Invision Power Board.

[josh48202]

anyone know how to do that?

[dbo]

As was already mentioned you don't connect to a specific table. You connect to the database and the you run queries on a table.

[josh48202]

ooo alright i got it thx m8