mysql_query problem

Hi,

I get an error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /.../.../select.php on line 11
writing=Error

but i dont know what is wrong.. please take a look at my code:

PHP Code:

---

<?php
//Capture data from $_POST array
$sender_id = $_POST['sender_id'];

//Connection to database
$connect = mysql_connect("myhost","myname","mypass");
mysql_select_db ("blablabla1", $connect);
//Perform the query
$result = mysql_query("SELECT naam_verzender, tekst1, tekst2 FROM Ecards WHERE ID=$sender_id");

while($row=mysql_fetch_array($result))
    {
            echo "naam_verzender=$row[naam_verzender]&tekst1=$row[tekst1]&tekst2=$row[tekst2]&";
    };

if($result) echo "writing=Ok";
else echo "writing=Error";
?>

---

thx,

mysql_query returns false when it cannot connect with the database or when the query contains an error. However, it does not throw an error itself. When you pass that false query $result to mysql_result(), mysql_fetch_array(), etc. those functions will throw the error you've received.

Either the db has not been properly selected, or the query is not working (one thing that jumps out at me is at ID=$sender_id ... the POST might not be coming through, or the name of the column might be `id` instead of `ID` and depending on your mysql settings, this may be caps sensitive, which is the default for mysql 5).

Suggested steps to resolution would be to add a tracer into your code, before it hits the error point, e.g.

PHP Code:

---

$errorfile = fopen("error.txt","w");
fwrite($errorfile,"SELECT naam_verzender, tekst1, tekst2 FROM Ecards WHERE ID=$sender_id"); 


---

Then look at the file generated and try to test the query as it appears using phpMyAdmin or on the mysql command line to see if it works. If the query does work, then the problem is that the db is not properly selected.