query error

[lilRachie]

hi, I need help
I had

$sql = "SELECT FROM database.table WHERE table.email = '$email'";
I tried
$sql = "SELECT FROM database.table WHERE email = '$email'";
it didnt work got same error

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/myurl/public_html/join/join.php on line 9
(that's line 7)

$sql = "SELECT * FROM database.table WHERE table.email = '$email'"; // line 7
$ExecuteQuery = mysql_query($sql); // line 8
$row_count = mysql_num_rows($ExecuteQuery); // line 9

Any clues?
lilRachie

[ahundiak]

You probably want:
SELECT * FROM table WHERE email = '$email'

but put
if (mysql_errno()) die(mysql_error());
After the mysql_query statement. It will provide more info.

[lilRachie]

I tried

SELECT * FROM table WHERE email = '$email'
and got:
No Database Selected

SELECT * FROM database.table WHERE email = '$email'
and got:
select command denied to user: 'myuser@localhost' for table 'table'

I'm at a loss as it worked on my old server.

TIA
lilRachie

[prinzcy]

err...did you define the connection first, i meant for the db before you use select?

[lilRachie]

yes
i use
include("connect.php");

connect.php looks like this
<?

$db_name="dbasename";
$host_name="localhost";
$user_name="myuser";
$user_passwd="mypass";
$db_conn = mysql_connect($host_name, $user_name, $user_passwd) or die("Could not connect: " . mysql_error());
mysql_select_db($db_name,$db_conn);

?>

[prinzcy]

maybe you could try

SELECT * FROM table WHERE email = '$email'

instead of

SELECT * FROM table WHERE email = '$email'

[gersh]

if you are trying to put it in a string it should be
$sql='SELECT * FROM table WHERE email =" '.$email.' " ';

[prinzcy]

but i used

$sql="select from table where email='$email'";
$runtest=mysql($sql) or die(mysql_error());

this work though...😕

[lilRachie]

All is working now.

Thanks for the help.

I'm going to start a new thread, please help me there too.

😃
lilRachie