Weird mySql problem

[JJBlaha]

I have a mysql code like

 

$sql = "SELECT * FROM table";
$result = (@mysql_query($sql, $dbh) or die(mysql_error()));
if($result) { echo "success!"; }

 

This outputs 'success!'.

 

If i then try to count the rows like this

 

$sql = "SELECT * FROM table";
$result = (@mysql_query($sql, $dbh) or die(mysql_error()));
$num = mysql_num_rows($result);
echo "num is $num";

 

It outputs 'num is '.  I get the same type of thing when i try mysql_fetch_array.

[teng84]

echo "num is $num";

 

 

try this

echo "num is". $num;

if $num has a value that should work

[JJBlaha]

that changes nothing in the output

[JJBlaha]

also i could insert into the table just fine, so i know it is not having trouble connecting to the database, just counting rows and getting information from rows.

[teng84]

try to remove the @ sign and test if the query has a value

or var_dump($result);//see if theres an output

say

pint_r(mysql_fetch_assoc($result));

[JJBlaha]

print_r(@mysql_fetch_assoc($result));

 

prints nothing

 

if i remove the @ from anything i get a warning, but the output does not change otherwise.

[teng84]

maybe the error is the word table maybe is a reserve word for mysql

try to rename it or i say put `table` but stop using table as table name think of other table name instead

 

[JJBlaha]

it is not really named table, and it is encased in ``.

[teng84]

first post that you have will surely output success because the errors are then in ur variables

so it will return true

 

i dont understand why its not working ok

debugging

try to query first in your db

copy the query and past it to my sql look if theres a result

[JJBlaha]

ive gone into phpmyadmin, done a query that works, and copied in.  it is not the query, it has to be something else.  what that is i have no idea.  i have tried everything i can think of, nothing helps.  this code works on other servers.  so it has to be something with my server, but i do not know what.

[teng84]

remove the @ and tell us the warning that might help

 

[JJBlaha]

it gives these

 

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in ...

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in...

[teng84]

it gives these

 

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in ...

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in...

 

 

those errors simply telling you that you have an error upon querying and statements are invalid

can u send me the real code the causing you trouble

[JJBlaha]

I dont think you can help me.  I tried everything you asked before I came here, the code is sound, it works on other servers.  I need to know what setting on my server is causing this problem.

[trq]

The code is NOT sound. Those errors indicate your query has failed.

 

Post your actual code and please, remove any error suppression (@).

[JJBlaha]

no, i added those errors IN, there are no errors.

$sql = "SELECT * FROM `random`";
$result = (@mysql_query($sql, $dbh) or die(mysql_error()));
print_r(@mysql_fetch_assoc($result));
if($result) {
$num = @mysql_num_rows($result);
echo "num is" . $num;
}

 

prints 'num is'.  this means that $result is true, but that $num has a null value.  inserting into the table works, but if i try to retrieve data the variables are empty.