Jump to content

PHP function /return/ /sql query/


w1ckd

Recommended Posts

Hey, My first post but not my last:)

 

I have just started with php or well just, i am in a learning progress.

 

i am trying to make function but somehow it gives me on every way a *Fatal error : SQL error *

 

The function looks like:

 

function sed_get_previewimage()
{
$res = sed_sql_query("SELECT att_path FROM $db_attach WHERE att_type = 'pag' AND att_item = {$pag['page_id']} AND att_img = 1 ORDER BY att_id LIMIT 1");
if(sed_sql_numrows($res) == 1)
{
	$att = sed_sql_fetcharray($res);
	$prev_path = att_get_preview($att['att_path']);
if(!file_exists($prev_path))
	att_create_preview($att['att_path']);
	echo "<img src="'.$prev_path.'" alt="" />";
}
else
	echo "No screenshot uplouded";
}
}
$previewimg = sed_get_previewimage();

 

This should be more then logic but somehow it gives me the error?

Link to comment
https://forums.phpfreaks.com/topic/155332-php-function-return-sql-query/
Share on other sites

Thank you for the reaction.

 

Here is the error :

2009-04-23 04:05
Fatal error : SQL 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 'WHERE att_type = 'pag' AND att_item = AND att_img = 1 ORDER BY att_id LIMIT 1' at line 1

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.