I am trying to select all the values from a column called "08" in reverse numerical order. When I run the following- every row returned has a value of 8- even though the actual values in the database are numbers like 236- 36- and 5. Why does the following Select statement not return the actual numerical values in the column called "08"? The column called "08" has a field type of INT(08).

$result = mysql_query ("SELECT 08 FROM May08 ORDER BY 08 DESC");

while ($row = mysql_fetch_array ($result)) {

$val=$row[ 08 ];

echo $val;

}

mysql_query("UPDATE songs SET rating = ".$rating." WHERE song_name = ".$song_name." WHERE username = ".$username." ")or die ("NOT WORKING!");

Okay- the code above doesn t work- I want it to double confirm the row that has the song_name = $song_name and the username = $username. Uh.. there s php in there too.
Thanks!

I have the following query for mysql but it keeps giving me an error and I am not sure why

"SELECT pd.products_name- pd.products_description- pd.products_url- p.products_quantity- p.price-p.products_weight-p.products_model-p.product_status from products_description pd- products d- where p.products=
{$_GET[ id ]}
and pd.products_id=
p.products_id "

I realize that I am not gaurding against the SQL injection I was plugging value in for testing.
the problem is in the where statement

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near where p.products= 8574 and pd.products_id= p.products_id at line 1

Can someone help please?

I would ve emailed yahoo about this- but couldn t find a support email address. I want to use the latest version of Wordpress and I want to use a PHPBB3 forum on my website- but I only know the username & password for my MySQL Database(s). Both of these softwares require a DSN (or DNS i don t remember what it is) & a database name to install them correctly- and I can t create a new database. I would prefer Yahoo! would update their softwares within the small business control panel- including Wordpress & PHPBB. But- since that seems unlikely- I was wondering if:
-Anyone knew a support email address for Yahoo?
-Anyone knew how I can make a new MySQL database?

I need to migrate a MySQL database from one host to another. If I export the passwords column from my user table- which is stored as BLOB and encrypted using the AES_ENCRYPT function- will that be successful- or does the AES_ENCRYPT vary machine-to-machine?

I guess the real question is- if I pass AES_ENCRYPT("somestring"-"somekey") to MySQL on two different machines- will the result be equal?

I read that mysql should hold links to the images on your filesystem instead of the images themselves. That being said- how would I format something like: C:\pictures\pic1-food-groups.jpg?