Some help with some php mysql communication.

[Sheepoholics]

Okay so I'm trying to make a online store using php mysql and flash but I can't seem to get tit to work.

Warning:  mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /backup/home/mitchell/public_html/products.php on line 12

This is the code in its entirty

<?php

$link = mysql_connect("localhost","*****_*****","*****");
mysql_select_db("mitchell_test");

$query = 'SELECT * FROM products';
$results = mysql_query($query);

echo "<?xml version=\"2.0\"?>\n";
echo "<products>\n";

while($line = mysql_fetch_assoc($results)) {
    echo "<item>" . $line["product"] . "</item>\n";
}

echo "</products>\n";

mysql_close($link);

?>

Asterixs are the username and password for the database.

Basically what the code should do is display the names of all the rows in the table. But All I get is the error.
this is just the begining steps to my project from here the php will create some xml which the flash file will read.

[Jake]

just use mysql_fetch_array() ;)

[Sheepoholics]

Now I get the same error except with Mysql_fetch_array() instead of mysql_fetch_assoc()

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /backup/home/mitchell/public_html/products.php on line 12

I'm really confused.

[Jake]

try:

$results = mysql_query("SELECT * FROM `products`);

echo "<?xml version=\"2.0\"?>\n";
echo "<products>\n";

while($line = mysql_fetch_array($results)) {
    echo "<item>" . $line['product'] . "</item>\n";
}

echo "</products>\n";

[Sheepoholics]

Now it thinks that the "?" is a parse error. It's telling me:

Parse error:  syntax error, unexpected '?' in /backup/home/mitchell/public_html/products.php on line 8

[clareto]

dont output the line that declares the document as xml with an "echo". Do it outside the php

 
<?php
 
... (code to initialize the db) 
// next line starts the output 
?>
 
<?xml version= ... ?>
 
<?
 
... (php code that makes the xml schema)
 
 
?>

[Jake]

yes that works well too. i normally try to minimize echo statements but when its 3am your kinda tired

and use <br> instead of \n

[Bryon]

Just for future reference, if your getting an error from a MySQL "result" function, try using "or die(mysql_error())" after your mysql_query(). You might have something wrong in your actual query, which causes nothing to be returned from the MySQL server, which could possibly be the cause of the error from mysql_fetch_array().

...
$blah = mysql_query("QUERY HERE") or die(mysql_error());
... 

(If you didn't know.)


Also you are getting that error because you forgot the "ending quote" in your MySQL query:

// Should Be:
$results = mysql_query("SELECT * FROM `products`");

// Was:
$results = mysql_query("SELECT * FROM `products`); 

;)

[Jake]

woops 3am mistake

[Sheepoholics]

Alright I got it all figured out. Just some little things needed fixing First off I needed to be selecting from a table that had and INT row. So after I fixed that and used or die(mysql_error()); (thanks for that Bryon) it was much easier to find the problem. And thanks to jake for all of the 3am help.