Passing data

harkly

I am new to php and cannot figure out how to move data from one page to another, I would like to do it in a URL. I don’t know the correct verbiage so it makes it harder for me to find this particular info.

I have a form, search.php, which passes the info to results.php which makes a list of all names in my database. I then want to click on the name(s) and have that pass the ‘artid’ to artist.php which will have detailed info on that particular name and some images which I want to be clickable, passing the ‘imgid’ to another page with detail info on the images.

So far my search.php works and I can get a list on the results.php but I can’t click on the name and pass that info on. All of my pages work independently.

In results.php I have:

echo “<a href=artist.php$id=artid>$fullName</a>\n”

I know a problem lies here (=artist.php$id=artid) but can’t figure it out. Do I need a form method on the search.php or am I completely off the mark here?

In artist.php:

$search=@_GET[“artid”];

$results = mysql_query(“SELECT * from image where artid like ‘AR3614’”);
My query works when I put in an actual ID (AR3614)

Could someone could point me in the right direction.

Protato

Take a look at the url for this thread and compare it to your structure.

http://www.phpbuilder.com/board/showthread.php?t=10360502
artist.php$id=artid

//maybe a typo in the post, but you have
@_GET['artid']
//when it should be
$_GET['artid']

Notice it has the url, variable name and value, look at what glues them together. Do the same thing when you need to know what glues multiple variables together.

also, if you use the php tags in your post it makes it much clearer to those helping.

harkly

I got the second pass to work but I cannot get the variable to pass to my URL. Here's my code,

mysql_select_db("artdb");

$search=$_GET["search"];

$result = mysql_query("SELECT * FROM artist WHERE fullName LIKE '%$search%'");

while ($r=mysql_fetch_array($result))

{

$fullName=$r["fullName"];

$dob=$r["dob"];

$dod=$r["dod"];

$nationality =$r["nationality"];

$choosen_medium=$r["artForm"];

$artid=$r["artid"];

echo "<a href=artist.php?artid=".$artid.">".$fullName."</a><br />";

}
?>

harkly

I was able to do it with

echo "<a href='artist.php?artid=$r[artid]'>".$fullName."</a>, ".$dob."<br />";

THanks!