Simple Results Page

Anon

I have already build a db and page that displays all the records in the table. But I am having a bugger of a time finding the right statements to just pull results for a single record over to another page.

I already have a $var passing through the URL to the new page (moreinfo.php). I really just need the MySQL statement. This is what I have now but it's not working.

<?php

global $HTTP_GET_VARS;
$event = $HTTP_GET_VARS['event'];

mysql_connect(localhost,$user,$pass);
$result = mysql_db_query("thinktpc","SELECT * FROM events WHERE (event_id = '$event')");

echo "Event Name: $event_name \n";
."Event Description: $event_desc \n";
."Start Date: $start_date \n";
."Event Ends: $end_date \n";

I get no errors but ZERO results with above.

Thanks for any and all help.

Jim

[deleted]

Jim - Don't forget that you have to do something like mysql_fetch_array on the $result... otherwise it's just sitting there, and ntohing has been assigned to $event_name and all the rest of the variables.

for instance:

$row=mysql_fetch_array($result)
    echo "Event Name: $row[event_name]<br>\n"; 
    ."Event Description: $row[event_desc]<br>\n"; 
    ."Start Date: $row[start_date]<br>\n"; 
    ."Event Ends: $row[end_date]<br>\n";

Anon

Karl,
Thanks much for the help. This worked for me.

Jim

<?php

global $HTTP_GET_VARS;
$event = $HTTP_GET_VARS['event'];

mysql_connect(localhost,thinktpc,esther0835);
$result = mysql_db_query("thinktpc","SELECT * FROM events WHERE (event_id = '$event')");

$row = mysql_fetch_array($result);

echo "Event Name: $row[event_name] \n"
."Event Description: $row[event_desc] \n"
."Start Date: $row[start_date] \n"
."Event Ends: $row[end_date] \n";

mysql_free_result($result);

[deleted]

Np. Just note that that you may get unpredictable results doing that if there is more than one row in the result set. You should really have some error checking in there... or at least, put it in a while loop.