Whats wrong with this query?

saltious

$query = "SELECT calls.callid, calls.duedate, calls.problem, users.forename, users.surname
FROM calls, users where calls.userid = users.userid AND calls.completed = 'Open'";

this for some reason does not return anything. all fields are corect. i just get zero results.

i tried this one too but it also doesn't return any results.. anyones help would be greatly appreciated.

$query = "SELECT calls.callid, calls.duedate, calls.problem, users.forename, users.surname
FROM calls INNER JOIN
users where calls.userid = users.userid AND calls.completed = 'Open'";

thanks ya'll

saltious

Me again.

theres something gone really wrong with my setup.

i have 2 records currently in my calls table. both were entered by two different users filling in the same form.

i run the following and only get one result. what on earth is going on?

$query = "SELECT * from calls";

$result = mysql_query($query) or die(mysql_error());

$row = mysql_fetch_array($result);

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

echo $row['problem'];

}
surely this query is correct?

what annoying is this was all working fin with the inner join query in my previos (above) post. then all of a sudden it stopped working properly and intermittently.

does anyone have any ideas? please my system is now ruined!!

thanks.

cahva

Get rid of "$row = mysql_fetch_array($result);" before the while-loop. Now when its there it will move the internal data pointer ahead by 1.

saltious

thanks cahva. that worked for my second post. any ideas about the above?

i think its links to the pulling the userid fields which are ints

should this query work.... cos it doesnt

$query = "SELECT * from calls where userid = '77'";

$result = mysql_query($query) or die(mysql_error());

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

echo $row['problem'];

i have tried putting the 77 out of the ' ' too.

cheers.

Kudose

If your userid datatype in the database is an integer, don't put quotes around userid

Have you verified you get results with:

SELECT * FROM users INNER JOIN calls ON users.userid = calls.userid