a little mysql help...

[thejustin]

hello -

im building a backend for users to update a frontend with product specials. i've got two php files doing the work.

inserts.php -> form to fill out, attach picture
sprocess.php -> process the information, inserts to database and renames the picture accordingly

i have another two files for doing the same thing basically but for artists instead of product specials.

inserta.php
process.php

i really just modified the field names in the database and a few of the form references for the product specials, but when i try to submit the inserts.php to call sprocess.php i get the following 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 sprod_id=3' at line 1

i don't really know what to check in the sprocess.php file to track this error down. the line is identical to the one in process.php which works.

process.php lines:

$sql1= "SELECT aimage FROM artist WHERE artist_id = '$artist_id' LIMIT 1";
$reslt2 = mysql_query($sql1, $conn) or die(mysql_error());
$pic=mysql_result($reslt2,0);
$path= "images/artists/$pic";
unlink($path);

sprocess.php lines:

$sql1= "SELECT simage FROM specials WHERE sprod_id = '$sprod_id' LIMIT 1";
$reslt2 = mysql_query($sql1, $conn) or die(mysql_error());
$pic=mysql_result($reslt2,0);
$path= "images/specials/$pic";
unlink($path);

any help would be greatly appreciated as i'm still learning 🙂

thanks,
justin

[bpat1434]

Are you sure that the table "specials" is there?

~Brett

[thejustin]

hey brett, thanks for responding.

yup, it is there. in fact one of the things things im trying to add is being added to the table.

here are all the things that should be added...

if (isset($POST['subsp'])) {
$spname = prepIn($POST['spname']);

$saname = prepIn($POST['saname']);
$sdesc = prepIn($POST['sdesc']);
$oprice_dollar = prepIn($POST['oprice_dollar']);
$oprice_cent = prepIn($POST['oprice_cent']);
$sprice_dollar = prepIn($POST['sprice_dollar']);
$sprice_cent = prepIn($POST['sprice_cent']);
$atype1 = $POST['atype1'];
$pstyle1 = $POST['pstyle1'];
$pstyle2 = $POST['pstyle2'];
$pstyle3 = $POST['pstyle3'];

the only thing its adding so far is the spname. so it's choking elsewhere i'm guessing just not sure where or what to change ...

[bpat1434]

Hmm.. break up your query onto different lines like this:

SELECT simage 
FROM specials 
WHERE sprod_id = '$sprod_id' 
LIMIT 1

Then, see what the error gives you. That will help narrow it down.

~Brett

[thejustin]

issue resolved thanks