Finding the right variable....

[NerotheWarlord]

Ok, I think I got the code in my script running correctly, but I'm having trouble figuring out the correct variable to make the if statement true for each category to show their respective links underneath them.

Can someone please have a look at this script and help me figure out the correct variable for the company name?

Right now, I'm using

$myrow['company']

But unfortunately that doesn't seem to be the correct variable, so the statement shows up false every time.

[NerotheWarlord]

Here's the attachment.

[tomhath]

Change each of your selects to only pick the rows you want. And remove the second part of the "if", you can't use $myrow in the same statement you set it, but you don't need it anyway.

I didn't test this but it should be close:

$result = mysql_query("SELECT * FROM `cbd` WHERE company = 'Crossgen Comics' ORDER BY 'name' ASC", $db);
if ($myrow = mysql_fetch_array($result))
{
	echo "<p><u>Crossgen Comics</u><br></p>";

	// display list if there are records to display
	do 
	{
           echo "<a href='$PHP_SELF?id=" . $myrow['id'] . "'>". $myrow['name'] . " \n<br />";
	} 
	while ($myrow = mysql_fetch_array($result));
} 
else 
{
	// no records to display
	echo 'Sorry, no records were found!';
	// single quotes are best to use when theres no variables in the echo.
}

[NerotheWarlord]

You are a god among men. :p

Thank you very much, I had no idea that there was a "WHERE" command. That makes it much easier. 🙂