Mysql Fetch Issues - within local fine

Question

I can execute the below query just fine in mysql console, but when try doing it in a php script, I got errors. Here' my query:

$tfa2_db=mysql_query("select * from `avotf`.`callerid_vault` ORDER BY `dateused` LIMIT 100",$stor);
while ($tfa2 = mysql_fetch_row($tfa2_db)) {

When I run the php file, it's giving me the following:

mysql_fetch_row() expects parameter 1 to be resource, boolean given

it's telling me i have a boolean given for my query. I am unsure what is wrong.

Any kind of help is greatly appreciated.

You are not doing proper error checking: http://php.net/mysql_error — Pekka, Apr 23 '13 at 08:07
Please find a couple of usage examples in the manual page for [mysql_query()](http://php.net/mysql_query). — Álvaro González, Apr 23 '13 at 09:19
off topic, but please note that the `mysql_xxx()` functions are deprecated. It is recommended to switch your code to use the PDO library instead. — Spudley, Apr 23 '13 at 10:28

score 0 · Answer 1 · answered Apr 23 '13 at 08:08

0

That means your qurty most likely failed and returned false, I'd find the error in the log and try to figure it out from there.

answered Apr 23 '13 at 08:08

Lemon Drop

Database connection will return true in this case, it's the query where he is going wring, probably mistake in table spell etc – Mr. Alien Apr 23 '13 at 08:08
@Mr.Alien Well the query I ment – Lemon Drop Apr 23 '13 at 08:09
query is fine since it loads fine in mysql console – thevoipman Apr 23 '13 at 08:13

1 Answers1