Having trouble ..

[KornChild]

I'm newb so please dotn make fun of me 😛 but .. when doing an action=confirm .. everything that it puts into the table shows up as resource id #something :-/ take a look at my code and tell me how i can fix it (i kno i probally used more querys than i have to .. if u can think of any other way to improve my code, please share)

EDIT - OK .. I changed the querys and put them into fetch_arrays .. which solved the resource ID problem .. but now no info is being written into the ruboonia_ref_$newref table, just blank spots .. help please!

<?
if($action == "confirm") {

$quer1 = $db->query("SELECT username FROM rubrefswaiting_$newref WHERE cid='$cidnum'");
$quer2 = $db->query("SELECT email FROM rubrefswaiting_$newref WHERE cid='$cidnum'");
$quer3 = $db->query("SELECT comments FROM rubrefswaiting_$newref WHERE cid='$cidnum'");
$quer4 = $db->query("SELECT rate FROM rubrefswaiting_$newref WHERE cid='$cidnum'");
$quer5 = $db->query("SELECT date FROM rubrefswaiting_$newref WHERE cid='$cidnum'");
$quer6 = $db->query("SELECT ip FROM rubrefswaiting_$newref WHERE cid='$cidnum'");

$username = $db->fetch_array($quer1);
$email = $db->fetch_array($quer2);
$comments = $db->fetch_array($quer3);
$rate = $db->fetch_array($quer4);
$date = $db->fetch_array($quer5);
$oip = $db->fetch_array($quer6);

$db->query("INSERT INTO ruboonia_refs_$newref (`username`, `email`, `comments`, `rate`, `date`, `ip`) VALUES ('$username', '$email', '$comments', '$rate', '$date', '$oip')");

}
?>
</table>
<BR><BR>
<?
eval("\$footer = \"".template("footer")."\";");
echo $footer;
?>

[pnoeric]

dude, you're makin' my head ache! try re-posting but post JUST the part of the code that is not working... break down the problem, cut the parts of the script that you have tested and that you know work well... etc. :-)

[KornChild]

lol sorry .. well thats the part i think is giving me trouble .. everything gets put fine into the rubrefswaiting$newref table .. but then it wont move into the ruboonia_refs$newuser table, it just puts blank fields =/

[pnoeric]

ok, so rather than send the SQL query to the databse, try echoing it to the screen and see exacrtly what is being written out.

[mrmufin]

Your field names shouldn't be wrapped inside backticks in the INSERT statement. There's a good place to start the debugging process...

There are far too many SELECT queries. You can grab everything you need with one query:

"SELECT username, email, comments, rate, date, ip FROM rubrefswaiting_$newref WHERE cid='$cidnum'";

[KornChild]

OK, thanks, i ended up using the fetch_row function ..