How to link from DB-variables between pages?

[eiler]

I need a little help with my new site... as a perfect newB:

I have made a calendar, as a simple list of events (date,event) pulled out of SQL database, using:

mysql_query("SELECT * FROM kalender ORDER by nr");

So far I have just made my list simple like in a guestbbok:

$NUMROWS = mysql_num_rows($QUERY);
if ($NUMROWS) {
$I = 0;
while ($I < $NUMROWS) {
$dato = mysql_result($QUERY,$I,"date");
$sted = mysql_result($QUERY,$I,"event");
..... etc ....

and then listing up using echo. Very simple, but effecient, since the list is attached to a "send in new events" - form.

Now heres the Question:
How do I link from the "event" to a new page with details about this event (and only this event!)?? I have tried using some old code getbykey, but since I'm new with the ID's and LINK-business, I cant get it to work.

In the detailed page, is of course just some more fields from the same DB-table, such as "description", "contact" etc.

Finally Id love to here from someone who knows how to output the above 2 fields from a DB ordered by date :rolleyes:

Appreciated...
Eilertsen

[cgraz]

Each event (or record) in the database probably has a unique id. You can use this id so you can query the database for just that particular event.

First make a link so that the script knows which record or event you want to pull out of the database

<a href="event_details.php?id=<? echo $id; ?>">

Then on the event_details.php page. . .

$query = mysql_query("SELECT * FROM kalendar WHERE id='$id'");

now just display the specs accordingly. If your id field is unique (or set to auto increment), this will only output one result.

Cgraz

[eiler]

Thanx a lot!
I still have a problem with the result.
In my first page I used the link as u said - I think...
The unique variable from the DB is called "nr".
It is from this ID that I try to get the event_details shown in a new page:

$QUERY = mysql_query("SELECT * FROM kalender ORDER by dato");
$NUMROWS = mysql_num_rows($QUERY);
if ($NUMROWS) {
$I = 0;
while ($I < $NUMROWS) {
$dato = mysql_result($QUERY,$I,"dato");
$sted = mysql_result($QUERY,$I,"sted");
$titel = mysql_result($QUERY,$I,"titel");
$nr = mysql_result($QUERY,$I,"nr");
echo "$dato";
echo "$sted";
echo "<a href=\"k_details.php?id=$nr\">$titel</a>";
$I++;}}

...and then comes the trouble in a result resource Warning:

$QUERY = mysql_query("SELECT * FROM kalender WHERE id='$nr'");
while ($DATA = mysql_fetch_row($QUERY))
echo "<center><u><b>$DATA[2]</u></b><br>$DATA[3]<br></center>";
echo "<table align=\"center\" width=\"50%\" border=\"1\" cellspacing=\"0\" cellpadding=\"2\">";
echo "<tr><td>Sted:</td><td>$DATA[4]</td></tr>";
echo "<tr><td>Beskrivelse:</td><td>$DATA[2]</td></tr>";
echo "<tr><td>Person:</td><td>$DATA[5]</td></tr>";
echo "<tr><td>Info:</td><td>$DATA[6]</td></tr>";

Can U see whats the prob? Think it must be with the fetch_row()

Thanx again
Eilertsen

[cgraz]

I think the problem is that the mysql isn't returning anything because your field name isn't called id, but it's called nr. If nr is the field that has soemthing unique assigned to it, then you'd need to

$query = mysql_query("SELECT * FROM kalendar WHERE nr='$nr'");

Make sure these variables have values assigned to them. If you're pulling $nr out of hte database, i'm guessing you put it into an array by doing something like

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

then to call $nr, you would need to use $row["nr"]

$nr = $row["nr"];
$query = mysql_query("SELECT * FROM kalendar WHERE nr='$nr'");
// now $nr has a value assigned to it

On the first page where you make a link, you'll also have to change id to nr

// But remember to change the first page to
echo "<a href=\"k_details.php?nr=$nr\">$titel</a>";

while ($DATA = mysql_fetch_row($QUERY)) {

echo "<center><u><b>$DATA[2]</u></b><br>$DATA[3]<br></center>";
echo "<table align=\"center\" width=\"50%\" border=\"1\" cellspacing=\"0\" cellpadding=\"2\">";
echo "<tr><td>Sted:</td><td>$DATA[4]</td></tr>";
echo "<tr><td>Beskrivelse:</td><td>$DATA[2]</td></tr>";
echo "<tr><td>Person:</td><td>$DATA[5]</td></tr>";
echo "<tr><td>Info:</td><td>$DATA[6]</td></tr>";

// close the while statment
}

That should work. Just make sure all your variables have values. You can try echoing them to see if they out put anything:

For example:

echo "NR: " . $row["nr"] . "";

// or

echo "NR: " . $nr . "";

Let me know if you need any more help

[eiler]

Thank You very much!

It work spendidly
- though without setting the variables as you suggested;

$id = $row[]

Still - it's working sofar....

Thanx again
Eilertsen😃