Reading data from MySQL

[tthurgo]

Hi,

I have a little problem with my code. I am trying to read data from a MySQL database using PHP. My code is as follows:

PHP Code:

$query = "SELECT products.id,products.name,products.desc,addons.parent,addons.id,addons.name,addons.desc FROM products WHERE cat=cars LEFT JOIN addons ON addons.parent=products.id ORDER BY products.name";

$raw=MYSQL_QUERY($query);

while($arr=MYSQL_FETCH_ARRAY($raw)){

echo $arr["addons.id"]." ".$arr["addons.name"]." ".$arr["addons.desc"]."<br>";

} 


This is what I use, I get no output though.

Tom

[Till]

Hi Tom!

Well, your problem could be of various reasons.

Is the connection to your database open?

Do you actually "select" anything? Use this code snippet to test your query (after $raw=MYSQL_QUERY($query)):

PHP Code:

if(!$raw)
echo "error: ".mysql_error(); 


And this, to see if you got any results:

PHP Code:

if(MYSQL_NUM_ROWS($raw) > 0)
echo "results"; 


Next one. I encountered some problems when using a "dotted" fields in an array as well, try this:

PHP Code:

$query="SELECT products.id AS ProductID FROM products";

$raw=...

$arr=...

echo "Product ID: ".$arr["ProductID"]; 


Just an example, but I guess you get the drift.

Hope that helps!

--
Till

[tthurgo]

Was the dotted array. Thanks for your help!

Tom

[Till]

You are very welcome!