[SOLVED] [MYSQL_QUERY] Retrieving a text field from mysql....error!

[flaab]

Good morning =)

 

I'm having a little problem retrieving a text field(not varchar) from a Mysql Table. Here is the code...

 

$result=mysql_query("SELECT desc FROM `retosP` WHERE id = '$pid' ");

 

Desc it's a text field. Every other fields just work fine.

 

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 'desc FROM `retosP` WHERE id = '' at line 1

 

How can i do this?

[paul2463]

desc is a reserved word in mysql,

 

try this

<?php
$result=mysql_query("SELECT `desc` FROM `retosP` WHERE id = '$pid' ");
?>

[flaab]

God  bless you!!

 

It worked.

 

Thanks!