Not sure how to do this, just starting

nspace

Hello all, this is my second day w/ php and mysql and I am not sure how to do something that I have been trying to do.

I have a database with a table called web.

Web has the following columns:

autoID, client, when, mediums, url, image, info

Basically what I have been able to thus far, is to get a list of the clients sorted alphabetically on one page from the database.

What I want to be able to do is when the user clicks on one of the client names, and send assign values from that clients row or autoID to $client, $when, $mediums, $url, $image, $info and post them to another file.

I don't know if I can just post the id number to the file and use it to reconnect to the db and access it like that (know idea how i can target a specific row), or is there some other way to do it?

Thanks in advance!

dnast

Originally posted by nspace
I don't know if I can just post the id number to the file and use it to reconnect to the db and access it like that (know idea how i can target a specific row), or is there some other way to do it?

Yes, that's one way to do it. Just pass 'autoID' and retrieve the record for that specific ID.

The query would be something like:

SELECT * FROM web WHERE autoID = '$autoID'

Just fetch the array and now you have access to the data for that one ID.

nspace

Hey, thanks. Just tried it but it dosnt seem to work. This is what i have:

Im passing the id variable onto the page like:

web_view.php?id=3 (or whatever clients that id is)

	$useid = $_GET["id"];  	  	
$query2 = "SELECT * FROM web WHERE autoID = '$useid'"; $results2 = mysql_query($query2, $connection);

$web_client = mysql_result($results2, "client");
$web_when = mysql_result($results2, "when"); 
$web_mediums = mysql_result($results2, "mediums"); 
$web_url = mysql_result($results2, "url"); 
$web_info = mysql_result($results2, "info");

However for someone reason it assigns the value of whatever the id is set to for every place i call $web_client, $web_when, $web_mediums, $web_url, $web_info

also I took this out for the code above because I wasnt getting any parse errors with this but when I add the line:

$web_image = mysql_result($results2, "image");

I get a parse error. Is image reserved?, its exactly how i have the column in the table named.

Thanks!

dnast

Your code appears correct. What exactly was the parse error?

Also, you could add

$row = mysql_fetch_array($result2);
echo "<pre>";
print_r($row);
echo "</pre>";

to the end and see what exactly is coming from the database.