1 reply to this topic

[nitr0x]

I've created a table for categories for a tutorial system, so categories can be added through the admin panel easily, but it doesn't show the name of the category but it does show the ID number in the url.

	$sql = mysql_query("SELECT * FROM `categories` ORDER BY `id` ASC");
	while( $r = mysql_fetch_object( $sql ) ){
		print '<a href="/index/category/'. $r->id .'/">'. $r->thename .'</a> ';
	}

Here's part of the source code.

<a href="/index/category/2/"></a> <a href="/index/category/3/"></a>

Any ideas? And yes, the field is called thename.

[Demonslay]

As usual, try debugging.
Output the object $r.

var_dump($r); // Inside your loop

If it doesn't work, and the value isn't there, you can always try arrays and using mysql_fetch_array(). If that still doesn't yield correctly, then there must be something wrong with the query not getting the data correctly (such as all the columns being blank).