listbox & db

[del753]

i have a listbox populated from the db, i just want to be able to select one of the choices and display the rest of the info of that record on the next page of the site, i can select anything no problem but nothing happens (except errors) on the next page where that records details should be displayed, heres my code so far...

<?php
include 'db.inc'
$result = mysql_query("Select Id, Time, Venue, where name = '$name'", $db);

?>

$name is my dropdown from the previous page, thanks for your help!

[bpat1434]

What error codes do you get?

Probably:
Query error: Syntax or no table.

Your query is weird. You have to watch the commas, AND define where to get the data.

Select Id, Time, Venue, where name = '$name'

No table name (FROM), extra comma. It should probably look something like:

SELECT Id, Time, Venue FROM table_name_here WHERE name = '$name'

That is probably what you're looking for.

~Brett

[del753]

thanks for the help, the error i'm getting is 'parse error unexpected T_variable in the select id line, still there trying your line..heres the revised version

<?php
include 'db.inc'

$result = mysql_query("SELECT ShowId, Date, Time, Duration, Venue, Price FROM shows WHERE name = '$name', $db);

?>

[bpat1434]

A good idea for debugging is this:
Write each SQL statement on a new line:

<?php
$query = "SELECT
        Id,
        Time,
        Venue
        FROM `table_name`
        WHERE name = '$name'";
$result = mysql_query($query);

This way, when you get the error message, you can now get a line number that corresponds to the query line number. Ingenious isn't it? I got it off of the thread on here about tips for debugging.

Also, check your code above the query. You may have missed something and PHP is only catching it then.

~Brett

EDIT
If that's a direct copy & paste, you're missing your closing quote.

[del753]

thanks doing it that way narrows down the problem i guess,
error = Parse error: parse error, unexpected T_VARIABLE in line 3

<?php
include 'db.inc'
$query = "SELECT
ShowId,
Date,
Time,
Duration,
Venue,
Price
FROM shows
WHERE name = '$Sname'";
$result = mysql_query($query);
?>

[bpat1434]

It's something previous to the statement that is breaking your script. what do you have in db.inc?

~Brett

[del753]

db.inc is just the connection to mysql........

<?php

//connection
$db = mysql_connect("mysql.internal", "xxx", "xxx")
or die("Couldn't connect to the database.");
mysql_select_db("xxx")
or die("Couldn't select the database");

?>

[bpat1434]

Found it:

<?php
include 'db.inc';
...
?>

You forgot to end the line.

~Brett

[del753]

you sir, are a life saver!, i am in your debt