Accessing Table Information

XXPCMXX

Well it is a bit more then accessing table information. What I can't figure out is how to access a whole row of information from a table.

Say my table looks like:

ID - Author - Title - Article

and I need to access ID = 1 and then with that ID number access the other information.

What command should I be using?

-Mike

twostepted

Are you using mysql? If so, you'll need to write a query such as :

// assign $id somewhere prior to this
$sql = "SELECT author, title, article FROM tableName WHERE id='$id';";
$res = mysql_query($sql);
$row = mysql_fetch_row($res);
// now you can access $row[author], $row[title], and $row[article]

tommynanda

In SQL terms

SELECT * FROM [I]table name[/I]  WHERE ID = 1

In PHP terms use

$result=mysql_query("SELECT * FROM [I]table name[/I]  WHERE ID = 1") // Execute Query and stores result in $result
$array = mysql_fetch_array($result); // Fetchs results into an array

$array[0] is ID
$array[1] is Author
$array[2] is Title
and so on

Good Luck

TommYNandA

XXPCMXX

That looks exactly like what I am looking for!

Thanks a lot!

-Mike

XXPCMXX

OK... I got all of the database information in and working (thanks again!). Now I was thinking... I imagine there is some way I can use that information for my updating recent news page as well. The thing is though it would have to access a new array of information for each article.

So is there a way to change function $id for each set of news?

ex:

Title \
Writer, Date - All of this information would use id=1
Description /

Title \
Writer, Date - All of this information would use id=2
Description /

and so on and so forth.

-Mike

twostepted

So you want to pull all the information out of the table?

$sql = "SELECT * FROM tableName;";
$res = mysql_query($sql);
while($row = mysql_fetch_assoc($res)) {
  // now you can access id, name, author... from the $row array
}

tommynanda

Couldnt get your Q, but I guess u r asking for something like this

for($id=1;$id<=10;$id++)
{
$result=mysql_query("SELECT * FROM table name  WHERE ID = $id")  

$array = mysql_fetch_array($result);
echo "Title: $array[2] <br> Author: $array[1]";
}

this is for 10 records, u can use a while loop if u dont know the number... if this is not wat u looking for be more specific

TommYNandA

XXPCMXX

Actually, I think that is what I was asking for. At first I didn't and then I realized you even took it a step further then I was looking for and hit it all... Thanks again! You guys are great.

-Mike