[SOLVED] how do i fetch data from mysql table?

[johnwayne77]

i connect to the db:

 

mysql_connect("localhost", "admin", "pass") or die(mysql_error());

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

 

now, i have a table called: 'shipment' with three fields:

 

tracking

name

address

 

I keep the tracking (which is unique) in a cookie for later use -- so I can do this :

 

$tracking = $_COOKIE['tracking'];

$check = mysql_query("SELECT * FROM shipment WHERE tracking = '$tracking'")or die(mysql_error());

 

Now, my problem is that I need to echo the name and address for tracking and I don't know how.

 

How do I do that? Any Ideas?.

[wildteen88]

Now loop through the result set with a while loop:

 

while($row = mysql_fetch_assoc($check))
{
    echo $row['name'] . ' - ' . $row['address'] . ' - ' . $row['tracking'] . "<br />";
}

[Orio]

Read some basic php-mysql tutorials....

 

<?php

$check = mysql_query("SELECT * FROM shipment WHERE tracking = '$tracking'")or die(mysql_error());
$row = mysql_fetch_array($check);
echo $row['name']." Lives in ".$row['address'];

?>

 

 

@wildteen88- You're faster But no need for a loop, "tracking" is unique.

 

Orio.

[ldsmike88]

You have to put the query into an array like so:

 

$shipment = mysql_fetch_array($check);

 

then to display the rest you would do echo it like this:

 

echo $shipment['name'];

 

or

 

echo $shipment['address'];

 

I hope this helps!

 

 

[johnwayne77]

thanks for the solution

 

mmmyeah, I guess basic mysql knowledge ... gotta read more

 

cheers~

[wildteen88]

Didn't see the where clause in the query there Orio. I thought it was just a normal Select all from table. I quickly read the post properly.