Creating a linked list???

bbsemail

I am fairly new to php/mysql and have a database with 3 tables. The first table holds users, the 2nd table holds ads and 3d table is supposed to hold the id field from each of the first two tables. If I execute my first query, it runs fine: (This query should only execute for a new user)

$queryUser = mysql_query("INSERT INTO users (userNum, user_id, username, email, MemberNumber, firstName, lastName, city, state, zip, country, phone, password, balance, totalAds) VALUES ('', '$user_id', '$username', '$email', '$MemberNumber', '$firstName', '$lastName', '$city', '$state', '$zip', '$country', '$phone', '$password', '$balance', '$totalAds')");

My second query that inserts the ad also executes without error:

$queryAd=mysql_query("INSERT INTO adtable (adNum, userNum, AdName, AdType, paidFree, adTitle, adText, Display, Comments, pic1, pic2, pic3, pic4, pic5) VALUES ('','$userNum','$AdName', '$AdType', '$paidFree', '$AdTitle', '$AdText', '$Display', '$Comments', '$pic1', '$pic2', '$pic3', '$pic4', '$pic5')") or die("Insert Error: Could not insert your ad in the database. ".mysql_error());

Next, I grab the record number from the last query's auto increment field so I know what the ad # is:
$lastIn=mysql_insert_id(); //--- last record # added to database

However, the third query that I want to use to link the two tables fails:

$queryC=mysql_query("INSERT INTO classifieds (classNum, userNum, adNum, submitDate, approvedDate) VALUES( '', '$userNum', '$lastIn', '$submitDate', '' ") or die("Error: Couldn't creat linked reference".mysql_error() );

Does anyone have any idea what I am doing wrong? Thanks for the help.

brad

devinemke

what does [man]mysql_error[/man] have to say?

bbsemail

Thank you for the help. The error doesn't appear very helpful:
8Error: Couldn't creat linked reference You have an error in your SQL syntax near '' at line 1

This part "Couldn't creat linked reference" is my code if an error occurs on insert. Again, thanks for any assistance.

dp777

It sounds like its just a syntax error. Let's look at your query:

INSERT INTO classifieds (classNum, userNum, adNum, submitDate, approvedDate) VALUES( '', '$userNum', '$lastIn', '$submitDate', '' ")

Ok, you have classNum = ''
user num = $userNum
adNum = lastIn
submitDate = $submitDate
approvedDate = ''
And it looks like here's your error...
VALUES( '', '$userNum', '$lastIn', '$submitDate', '' ")
^
after $submitDate you have " '' you might be missing a column, and in that case you are missing a , in the VALUES portion. Or you just might ahve typed an extra ''

If that doesn't fix the problem, build, but do not execute queryC and do an echo $queryC and take a look at what the query looks like, maybe try cutting and pasting it into the command prompt and see what errors that gives.

HTH!

bbsemail

Thank you ... Do I have a brain ... I was playing with additional fields in the query and lost track of where I was. Thanks a lot with your patience and your help.

It works fine now, and I added the code to insert the date in the submitdate field and it's done. Thank you.
brad