refuses to work as always

[delemtri]

<?php include("idnum.php"); include("dbconn.php"); if ($pword==$insertpasswordhere) { 
$result = mysql_query("select * from queue");
while ($row = mysql_fetch_assoc($result)) {

$sname=stripslashes($row["sname"]); $semail=stripslashes($row["semail"]); $artist=stripslashes($row["artist"]); $lartist=stripslashes($row["lartist"]); $title=stripslashes($row["title"]); $bwith=stripslashes($row["bwith"]); $lyrics=stripslashes($row["lyrics"]); $sdate=stripslashes($row["sdate"]); $sid++;

$blargh = mysql_query("insert into lyrics (sname, semail, artist, lartist, title, bwith, lyrics, sdate, sid) values ('$sname', '$semail', '$artist', '$lartist', '$title', '$bwith', '$lyrics', '$sdate', '$sid')");

}

$handle = fopen("idnum.php", 'w');
fputs($handle, "<?php \$sid=$sid; \$qid=$qid; ?>");
fclose($handle);

$result = mysql_query("delete * from queue");
} else { echo "Incorrect password."; } ?>

I'm guessing that the $blargh query is failing. But what am I doing wrong?

[DR_LaRRY_PEpPeR]

need more info. how's it failing? any error message?

[delemtri]

No error message, it just sorta sits there.

[DR_LaRRY_PEpPeR]

ok, well is that the whole script?

as long as you don't have an incorrect password it doesn't look it echo()s anything... so it would appear to just sit there. i just noticed that.

[delemtri]

Uhh, I know this, I wrote the script...

Trouble is, it doesn't do anything to the database either.

[timnz]

Why don't you tag "or die (mysql_error())" onto the end of the mysql_query, to see if that sheds any light onto why it isn't inserting it into the database.