mysql

[Anon]

Hi, I'm hanafiah

I having some problem with mysql. I'm using php and mysql. What problem now is I try to retrive some data from mysql, if the data is there (in mysql) I not having any problem but if the data not exist, so it return an error: Unable to jump to row 0 on MySQL result index 2:

can anybody help me on this, I know my code are wrong, can any body give suggestion on how to solve this problem, below example of my code for your review:

---

$searching = "select user from user where host='$hostname' and user='$username' and password=password('$password')";
$query = mysql_query($searching,$db);
$validuser = mysql_result($query,""); // error will occur when execute this line and no such data in mysql

---

[Anon]

hi,

you should check your result handle (ie. the thing returned by mysql_query). If it\'s zero, then something\'s gone wrong. So in general, check the result before doing anything with it.

alternatively, you could count the rows in the result. if there is one row then you know you\'ve succeeded...

so...

$searching = \"..whatever..\"
$result = mysql_query($searching);
$validuser = mysql_num_rows($result);

$validuser will then be 1 if the user is in the db, and 0 otherwise.

[Anon]

Hi, DOM

thank you a lot for you.. It solve my problem..

bye
hanafiah