can u c waht is wrong?

Anon

i have a page that gets the info from a form, puts it in the db, and then jump automaticly to another pafe thae showa this information from th DB.
for some reson, the info atays outside from the DB.
can u telll me what is wrong?

<?
mysql_connect("","","");
mysql_select_db("message");
$query_check=mysql_query("select * from users where un='$un'");
while($row_check=mysql_fetch_array($query_check))
{
if($row_check['pw']==$pw)
{
if(!session_is_registered('un'))
{
session_register('un');
mysql_query("insert into online values('$id','$un')") or die(mysql_error());
?>
<script>

</script>
<?
}
}
else
{
print"<div align='center' style='font-family:tahoma;'><a href='index.html'>...ìà èåá, ðñä ùåá</div></a>";
}
}
?>

Anon

PIKACHU I CHOOSE YOU!!!

Anon

try outputting your SQL query before you insert it andd se what you get .... it looks to me like you are trying to insert a record .... and I'm guessing that that record has 2 elements. The table you are inserting it into has how many collumns?

I find that if it isn't working it helps to output the error# and text after each mySql statement; it helps me nail down the error.

/REMOVE/
if (mysql_errno()){ // IF there is an SQL-ERROR => SHOW ME
echo "<font color=red>ERROR</font>: ".mysql_errno().": ".mysql_error()."<BR>";
exit;
}
/END REMOVE/

Anon

What wrong...

Your english and/or your typing. (sorry)
i'd echo the script rather than go out of php then back in.
un comment the script i find some time the  really screw things up it works with out them.
What is '>...ìà èåá, ðñä ùåá' ??? that certainly won't help.
What errors do you get it'll help narrow it down.

Anon

<?=SID?> what that eh?

Anon

about my english.. i'm tring |-;
Ok.
<!-- doesnt exist any more.
this is in hebrew - TRY AGAIN. that is the answer for a incorrect password.
i dond get any errors' it just doesnt seem to enter into the DB.
thanks

Anon

it has tow collumns.
i tried your way print errors, but nothing happand.
the rekord just doesnt goes in the DB, i tried to inser a string, it work, but the var isnt.
if i printing the var it is OK.
thanks

Anon

that is the SESION ID, dont u know waht is this?
it help me out when i'm working at my local area, with 2 sessions at the same time.
(like 2 users)

Anon

What about the part where I suggested that you output the SQL query before you tried to insert it. This method shows you visually what the query is and helps you verify that the variables have the information you believe thay do. It also permits you to copy and paste the EXACT code into the mysql interface to see if you could actually make the query work outside of the script. Which only permits you to verify that it is or is not your script that is jacking you around ....