Prob whit Mysql and forms

Anon

I'm trying to make a updatepage on info about members but i have run into a dead end... I get this message when i try it...

Warning: Supplied argument is not a valid MySQL result resource in d:\web\docs\darkeden\web\langtrue\login\update\upd_kar.php on line 12

This is the code...

<?php
global $id;
$link = mysql_connect("localhost","","") or die ("Unable to connect to MySQL server.");
mysql_select_db("raser");
$result = mysql_query("SELECT * FROM karaktarer WHERE id=$id");
line 12->$row = mysql_fetch_row($result);

And this is the code i'm trying to access the database with

what is the problem???
can anyone help me on this please...
//T-man

Anon

Echo the SQL statement before sending it to MySQL; see if that looks all right and proper:

echo "SELECT * FROM karaktarer WHERE id=$id";

In particular, does $id have the value it's supposed to? I don't see it getting set anywhere.

Anon

Hmmm.. i'm not following you how do you mean?

The id is sett by a loginscript i have done but it's the row thing that doesn't work

Anon

The reason I'm asking is that, assuming you're connecting to the database fine (and you're checking that), the next place where it can go wrong is mysql_select_db. If the database isn't there to be selected there'll be trouble.

After that the next suspect is the SQL statement itself, if $id isn't set to anything (and why are you declaring it global? Is this inside a function?) then the SQL statement will be invalid, which is why I suggested echo()ing it - just to make sure what's being sent to the database really is what you want to send.

One last thing I note is that you don't check to see if there are any matches found before trying to read them. This probably isn't the cause, but I wouldn't totally rule it out, either.

Anon

When i ran the script on a server it said that $id wasn't declaired and it went away when i made it global..

there something with the $row and read from a textbox that it doesn't like... couse i have used the same script using a table insted of formes and it did work but when i tried with form it didn't like the $row command... do not know at all why it's like that

Anon

The $row command itself is fine - that's just the spot where PHP realised something was wrong - MySQL didn't come back with a result set for some reason. Maybe the SQL was malformed (which would be the result of a bad $id) or there weren't any result rows to fetch (no matches for that id).

It wasn't declared because it was never set to anything. I can't remember if PHP's warnings are smart enough to realise it might have been set from outside PHP (ie., in the form).

Are you sure the form field is named 'id'?

If it is, try replacing "global $id;" with
"$id=$HTTP_POST_VARS['id'];" (or HTTP_GET_VARS if you're using a GET form) and explicitly tell the script's warning procedures that $id has that particular value.