Resource id #163

[Avery_Anthony]

Hello,
I'm doing a SQL query in PHP code and getting the result Resource id #163.

The query is SELECT * FROM xggirl_categories WHERE xggirl_category_modelid = $currentmodel

Do anyone know whats going on?

Avery

[e-mail]

Thanks for all your help

[LarsLai]

hi!
i do not think there is anything wrong with your query but with your php code afterwards.
so please post it if your problem still is up-to-date.

[Weedpacket]

The short answer is that instead of getting data out of the returned record set and outputting it, you're just outputting the recordset. Depending on which DBMS you're using, use one of the database functions with "fetch" in their names. That will give you an array; how you format the contents of that array as a string is up to you.

[Avery_Anthony]

/ query database for all users /
$sql_result = mysql_query("SELECT * FROM xggirl_categories WHERE xggirl_category_modelid = $currentmodel");

Hello
If you are curiouus to the code. Here it is. I will look at it tongith but I see nothing wrong with it.
Avery

/* query database for all users */
$sql_result = mysql_query("SELECT * FROM xggirl_categories WHERE xggirl_category_modelid = $currentmodel");	

/* loops through current categories for model */

if ($sql_result==0)
{
 echo "<tr><td>No Category Available</td></tr>";
 }else
while($row = mysql_fetch_assoc($sql_result))
{
	/* shows results if any */	    		 
	 echo "<tr><td><a href=\"admin.php?op=xggirl_photos&modelid=$currentmodel&category=$row[xggirl_category_id]\">$row[xggirl_category_name]</a>";
	 echo  "</td><td>&nbsp;<a href=\"admin.php?op=xggirl_categoryprofile&modelid=$currentmodel&category=$row[xggirl_category_id]\">Update Category</a>&nbsp;</td></tr>\n";

}

[Kudose]

Weedpacket, I hope someone pays you alot of money for your knowledge and see's you as an asset as you are on these boards.