house pic

[Saberman]

i am try to select the userids house pic but i get an error

$qn=$db->query("SELECT hsepics FROM houses where hsepics={$ir['hsepics']}");

$n=$db->fetch_row($qn);

does anyone know what it is

QUERY ERROR: 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 '' at line 1

Query was SELECT hsepics FROM houses where hsepics=

[CrazyT]

Re: house pic

That is totally wrong.

$house_picture = $db->fetch_single($db->query('SELECT `hsepic` FROM `houses` WHERE hWILL = '. $ir['maxwill']));
echo '<h3>House Picture</h3>[img=images/houses/'. $house_picture .']
';

 

Hope it helps...

[Saberman]

Re: house pic

 

That is totally wrong.

$house_picture = $db->fetch_single($db->query('SELECT `hsepic` FROM `houses` WHERE hWILL = '. $ir['maxwill']));
echo '<h3>House Picture</h3>[img=images/houses/'. $house_picture .']
';

 

Hope it helps...

Thank you very very much CrazyT mate this works perfectly +1

[CrazyT]

Re: house pic

 

That is totally wrong.

$house_picture = $db->fetch_single($db->query('SELECT `hsepic` FROM `houses` WHERE hWILL = '. $ir['maxwill']));
echo '<h3>House Picture</h3>[img=images/houses/'. $house_picture .']
';

 

Hope it helps...

Thank you very very much CrazyT mate this works perfectly +1

No problem :)