prob with select

[imnsi]

I am just trying to do a password checkup script and this is not seeming to be so easy...

Here is the code I have, the HTML form posts to the .php:

// connecting to the db
$link = mysql_connect ($host, $user, $pass);

// the db query
$q = "SELECT * WHERE Email = $email1 from $table";
$results = mysql_db_query ($db, $q, $link); 

echo "$results // ";
echo "$email1";

// fetching the results

while ($row = mysql_fetch_array($result)){

echo "$row[Password] ";

};

[andrin]

The correct SQL syntax you should use is probably:

// the db query
$q = "SELECT * FROM " . $table . " WHERE Email='" . $email1 . "'";

// or shortcut without conc :-)
$q = "SELECT * FROM $table WHERE Email='$email1'";

Happy Coding
/Andrin

[imnsi]

Ok, i think i have it working so far yet... I get an error on the line that uses the msql_fetch_array? Do you see something wrong with that? Also what does $results return, because it returns me a number right now.

$results = mysql_db_query ($db, $q, $link);

echo "$results <BR>";
echo "$email1 <BR>";

// fetching the results

while ($row = mysql_fetch_array($result)){

echo "$row[Password] ";

};

[sgoku01]

Your query is stored to $results and you want to fech $result (without the -s).