display.

jkatcher

id has been passed successfully to this page from another. once i've matched up the correct Id in the loop to the Id in my table, i want to display the data.

$query = "SELECT * FROM bands WHERE ID=' ".$_GET['ID']." ' ";
$result = mysql_query($query)
or die (mysql_error());

$num_results = mysql_num_rows($result);
$row = mysql_fetch_assoc($result);

// nothing is echoing onto the page...there is no value for ID

// I think...

echo ($row['name']);

any ideas?

LordShryku

echo the $query to the screen to see if the ID is populated there

jkatcher

ah. all i get from this code:

echo 'Query: '.$query.'';

is this:

Query: SELECT * FROM bands WHERE ID=''

the id's NOT coming through, what can I do?

LordShryku

Are you sure the id is there? Do you see it in the URL? Is the case right of your variable right(ie. $GET['id'] is differenct than $GET['ID'])?

jkatcher

I do get it in the URL...

CODE: echo '<a href="bMoreInfo.php?id='.$row['ID'].'" class="contact">More Info</a></td>';

URL PRODUCED: http://www.seattlebandsonline.com/bMoreInfo.php?id=12

...

ID is uppercase in my variable and table structure....what do you think?

LordShryku

ID is lowercase in you variable, so you should be using

$query = "SELECT * 
            FROM bands 
           WHERE ID='".$_GET['id']."'";

If the URL was bMoreInfo.php?ID=12, then you would use $_GET['ID']....

jkatcher

got it, it's workin. thanks for catching that, good eye!!