description selecting probz

[Ponick]

$item = mysql_fetch_array(mysql_query("SELECT uid, id, imageurl, sex, descript FROM ibwf_usergallery WHERE uid='".$whoimage."'"));


    $dscp = mysql_query($item);

echo"$dscp[4]"; 

whats wrong?? i dont get anything from this

can somebody tell me the right code ??

[ksg91]

do like this

$item = mysql_fetch_array(mysql_query("SELECT uid, id, imageurl, sex, descript FROM ibwf_usergallery WHERE uid='".$whoimage."'"));


 $des=$item[4];

echo $des; 

[wapmetal]

$item = mysql_fetch_array(mysql_query("SELECT  id, uid,  imageurl, sex, descript FROM ibwf_usergallery WHERE uid='".$whoimage."'")); 
echo "$item[4]";

[Ponick]

Thank you all
This won't work ,the main problem is data selecting . May be uid not the $whoimage!!

I did it in another way . Its
SELECT descript FROM ibwf_usergallery WHERE imageurl="'.$imageurl.'"
but its not good to keep path link in url
any way ,how can i insert a new field in a table.
Example i need to inser 'blabla' field in ibwf_users table .Then what to do?

[ksg91]

Thank you all
This won't work ,the main problem is data selecting . May be uid not the $whoimage!!

I did it in another way . Its
SELECT descript FROM ibwf_usergallery WHERE imageurl="'.$imageurl.'"
but its not good to keep path link in url
any way ,how can i insert a new field in a table.
Example i need to inser 'blabla' field in ibwf_users table .Then what to do?

ALTER TABLE ibwf_users ADD ( blabla varchar(50) );