Posted by miso on 09/14/07 15:30

I have problem with my php/sql code because id (auto inc., primary) row.
(
$sql = "INSERT INTO ".$_CONF['tprefix']."schedule_scores VALUES ";
$sql .= "('NULL','$newdate','$newtime','$newlocation','$team1_id',";
$sql .=
"'$team2_id','$team1_div','$team2_div','$newteam1_score','$newteam2_score',";
$sql .= "'$newseason','','','','','','1')";

)

this is code and i done this

(
$sql = "INSERT INTO ".$_CONF['tprefix']."schedule_scores (date, time,
location,
team1, team2, team1_div, team2_div, team1_score, team2_score, season,
summary,
pic_name, pic_caption, tourneyid, tourneygid, standings) VALUES ";
$sql .= "('$newdate','$newtime','$newlocation','$team1_id',";
$sql .=
"'$team2_id','$team1_div','$team2_div','$newteam1_score','$newteam2_score',";
$sql .= "'$newseason','','','','','','1')";
)

because i know that i have to avoid id row to get it work.

please help
Miso

• Next in forum: Re: php5 mysql5.0 win problems
• Prev in forum: Re: Unique constraint for the columns does not work when one of values is null.
• Thread view: php5 mysql5.0 win problems

[Reply to this message]