link the query results?

reisrui

Imagine I have a select query which returns various records, let´s say 20 lines.
I have for example columns named place, name, club, points.
I do a search with some form values and it returns the results on a normal table bellow, this is how it works now.

Is it possible to make each line of the result clickable, so it can open a popup with details about that specific line?
Let´s say I wanted to see details of one club (it´s another table) by clicking a line in which that club is presented.
How can I do this?

Thks,

etully

When you do your query that obtains "place, name, club, and points", you're also going to have to get a unique ID for each club. Let's say it's called club_id in the database and then when you read it out of the database, you put it in a variable called $club_id

So right now you're printing the list of records something like this:

print "<tr><td>$place</td>";
print "<td>$name</td>";
print "<td>$club</td><td>$points</td></tr>\n";

Right?

So now that you are obtaining each club's ID # too, then you are going to print the list of records like this instead:

print "<tr><td>$place</td>";
print "<td><a href=\"club_info.php?club_id=$club_id\">$name</a></td>";
print "<td>$club</td><td>$points</td></tr>\n";

Notice that I put <a> </a> tags around the Name. The Name is now a link to a file called club_info.php and when that file loads, you are passing a variable called $club_id. That way, the other script (called club_info.php) will know which Club the user wants more info about.

So then you create a PHP script called club_info.php with a select statement like this:

select * from club_data where id=$club_id

reisrui

thans etully!

I think I get it, problem now seems to be the syntax....
I´m trying to link the whole row (can I?), but I didn´t understand yet where should I put ' or "" when printing php code!!!
This is where I return the query result:

while($row = mysql_fetch_array($query)) {

$club=$row['club'];
echo "<tr>";
echo '<a href="popup.php?id=$club">';
echo "<td nowrap>".$row{'lugar'}."</td>";
//echo "<td nowrap>".$row{'zona'}."</td>";
//echo "<td nowrap>".$row{'prova'}."</td>";
echo "<td nowrap>".$row{'associacao'}."</td>";
echo "<td nowrap>".$row{'club'}."</td>";
echo "<td nowrap>".$row{'clubname'}."</td>";
echo "<td nowrap>".$row{'pontos'}."</td>";
echo "</a>";
echo "</tr>";

If I put like this, the popup opens with the name of the variable and not it´s content......
If I put like you did:
echo "<a href=\"popup.php?id=$club\">";
I get parsing errors........

etully

It didn't work because you changed my print statements to echo.

tsinka

Hi,

it doesn't matter if you use print or echo. The problem with

echo '<a href="popup.php?id=$club">';

is that php doesn't expand variables in single quote strings (only in double quote strings.

echo '<a href="popup.php?id='.$club.'">';

should work. The parse errors are most likely caused by missing backslashes to escape the double quotes within the string.

Thomas

reisrui

Thanks a lot, tsinka

That WORKED!

What a confusion about ' and ".... where can I read something about this?

tsinka

There's a nice chapter about strings in the manual

Thomas

mars16

tsinka wrote:
is that php doesn't expand variables in single quote strings (only in double quote strings.
echo '<a href="popup.php?id='.$club.'">';

am little bit confused, is that code line complete, what happened to the rest of the tag </a>. if it's not complete can you complte that line.

Am having problems displaying the text link part, is this correct ( the bold part):

echo '<a href="article.php?id='.$name.'">$row['name']</a>';

it works if i write normal text but but if i try as it is now the whole page is empty

Houdini

What does it show (the $row['name']) part?

mars16

if i do this:
echo '<a href="article.php?id='.$name.'">$row['name']</a>';

the page looks as though its loading then it stops, with nothing displaying at all.

But if i replace the bold part with noraml text like HELLO it will load up with hello showing as the link. So am assuming there is a mistake in my syntax

tsinka

Replace

echo '<a href="article.php?id='.$name.'">$row['name']</a>';

with

echo '<a href="article.php?id='.$name.'">'.$row['name'].'</a>';

Houdini

Try this instead because $row['name'] is an array variable so make it a simple variable like this

$name=$row['name'];
echo '<a href="article.php?id='.$name.'">'.$name.'</a>';
//or use double quote on the string
echo "<a href=\"article.php?id=$name\">$name</a>";

mars16

thanks tsinka, it works.

One more question, the page the link is going to, what do i need to put on there?

This is what I have so far but again it shows displays nothing at all BUT the address bar seems to be correct as its pointing to the right record.

<?php
mysql_connect("mysqlservr", "username", "pass") or die(mysql_error());
echo "Connected to MySQL<br />";

/*establish connection with database*/
mysql_select_db("databasename") or die(mysql_error());
echo "Connected to Database <br />";
$query = "select * from rtbarticles where id=$name; 


echo "<br />Name:".$row['name'];
echo " <br />Date: ".$row['date'];
echo " <br />Text: ".$row['text'];

?>

tsinka

I'd prefer one of the two examples Houdini posted.

About the last code you posted:

There's a syntax error in the $query line and you didn't execute the query and fetch the row at all.

Thomas

mars16

ok i agree too, will use Houdini's method, thanx Houdini

mars16

I corrected few tthings but still not working!

CODE:

<?php
/establish connection with MySQL/
mysql_connect("server", "username", "pass") or die(mysql_error());
echo "Connected to MySQL YES YES YES YES ";

/establish connection with database/
mysql_select_db("database") or die(mysql_error());
echo "Connected to Database ";

/store query string in a variable/
$query = "SELECT * FROM rtbarticles WHERE name='.$name.'";

echo "Following data retrieved from database ";
// Retrieve all the data from the "rtbarticles" table
$result = mysql_query($query)
or die(mysql_error());

$row = mysql_fetch_array($result)

// Print out the contents of the entry
echo " ID:".$row['id'];
echo " Name:".$row['name'];
echo " Age: ".$row['age'];
echo " Date: ".$row['date'];
echo " Text: ".$row['text'];

tsinka

A semicolon is missing at the end of the line

$row = mysql_fetch_array($result)

Thomas

mars16

thank you. Page is displaying normal text now BUT the database content is not showing

tsinka

I think register_globals is set to off, so you need to use $_GET['id'] instead of $name.

And there's still a syntax error in the query line:

$name = str_replace("'","\\'",$_GET['id']);
$query = "SELECT * FROM rtbarticles WHERE name='$name'";

You're submitting the name as get parameter. I think it might be better to submit the id instead.

Thomas

mars16

actually i am using the id but i copy n pasted a code i was expermenting with to find where am going wrong.

CODE:

<?php
/establish connection with MySQL/
mysql_connect("server", "username", "pass") or die(mysql_error());
echo "Connected to MySQL YES YES YES YES ";

/establish connection with database/
mysql_select_db("database") or die(mysql_error());
echo "Connected to Database ";

/store query string in a variable/
$query = "SELECT * FROM rtbarticles WHERE id='.$name.'";

echo "Following data retrieved from database ";
// Retrieve all the data from the "rtbarticles" table
$result = mysql_query($query)
or die(mysql_error());
$row = mysql_fetch_array($result);

// Print out the contents of the entry
echo " Name:".$row['name'];
echo " Age: ".$row['age'];
echo " Date: ".$row['date'];
echo " Text: ".$row['text'];