Windows <-> Linux MySQL Issues

[Anon]

$query = "SELECT * FROM ClientInfo WHERE Email = '$Email' AND Pass = '$Password'";

$resultid = mysql_query($query);
$RowsReturned = mysql_num_rows($resultid);

if($RowsReturned == 0)
{
print "There appeared to be no users with that email/password. Check your spelling and try again.";
}
else
{
//Continue the script....

In the example above, I've already selected mydatabase and and connected to it. Essentially this code just matches the Email and Password values of the database and matches it to the Email and Pass values it recieved from the previous page.

This code works just fine and dandy on my WinXP box but when it's transferred to the Red Hat 7.2 server my host uses, it won't query correctly. I've tested the query in the PHPMyAdmin tool using the PHP generated statements (I used print to grab them out) and the SQL syntax is ok. However it tells me that

Warning: Supplied argument is not a valid MySQL result resource in (the path of my account)

My guess is that this is some windows to linux issue in MySQL or PHP, but I don't know how to work around it. Is this a case sensitivity issue or some such? Just guessing.

Thanks,

-Artie

[ziggs]

I might be a little slow in the head but you need to first put these lines at the top before the $query.

<?php
$db = mysql_connect("localhost","username","password");
mysql_select_db("dbname", $db);

define username, password, and dbname. It should work. I don't know why WinXP didnt spit out the error but I dont even know if I am right. I have been wrong before (many times)....🙂 So try that and if works sweet if not then...well....wait for someone else's reply.
Ziggs

[zalath]

My WinXP box lets me connecto to the 'base with a plain mysql_connect(); with no args. In Linux you need to give the hostname, user and pass as arguments, or it won't connect. Is this possibly your case? if so, are you testing the success of the connection? it's a good practice to always test if the connection is there or not.

-L-