User Profile

tania

Last Activity: Jul 8 '06, 05:43 PM

Joined: Jul 7 '06

Location:

tania replied to error in your SQL syntax...ear 'Resource id #3' ???

in PHP

Jul 8 '06, 04:33 PM
plese help me....
thanks in advanced!

See more | Go to post
Leave a comment:
tania started a topic error in your SQL syntax...ear 'Resource id #3' ???

in PHP

Jul 8 '06, 04:32 PM
error in your SQL syntax...ear 'Resource id #3' ???

i have this query:
$query = mysql_query("SE LECT F_ID,F_TITLE,A_ FNAME,A_LNAME FROM (take_part INNER JOIN film ON F_ID = T_P_ID)INNER JOIN actor ON A_PID = ACTOR_ID WHERE A_PID=\"$a_id\" ");
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 'Resource id #3' at line 1

See more | Go to post
tania started a topic load the elements of a table into a form

in PHP

Jul 7 '06, 08:20 PM
load the elements of a table into a form

supposing we have a page where we submit an id and into the other page we want to load the elements of that id into a form...
How could we do that???

Thanks, Tania

See more | Go to post
tania started a topic Column count doesn't match value count at row 1

in PHP

Jul 7 '06, 07:59 PM
Column count doesn't match value count at row 1

i have this table in my database:
CREATE TABLE FILM(
F_ID INT(5) NOT NULL AUTO_INCREMENT,
F_TITLE VARCHAR(40) NOT NULL,
DIRECTOR_FNAME VARCHAR(20) NOT NULL,
DIRECTOR_LNAME VARCHAR(20) NOT NULL,
TYPE VARCHAR(30) NOT NULL,
DURATION TIME ,
YEAR_RELEASE YEAR NOT NULL,
DESCRIPTION TEXT,
RENT_TIME SMALLINT(2),
PRICE VARCHAR(4) NOT NULL ,
F_EMPLOYEE_ID INT(3),
PRIMARY...

See more | Go to post

No activity results to display

Profile Sidebar

Leave a comment:

error in your SQL syntax...ear 'Resource id #3' ???

load the elements of a table into a form

Column count doesn't match value count at row 1