$qry = "SELECT * FROM <code>wp_companies</code> WHERE 1=1 AND 'company_name' = 'Acme'"; $data = mysql_query($qry); while($r=mysql_fetch_array($data)); echo "<pre>".print_r ($r,true)."</pre>";
Anybody know why this would be returning an empty array? It seems so straightforward. No errors. Nothing in php error log either. When I put the sql statement into phpmyadmin it retrieves the correct row. Am I just missing something really simple? Sorry ahead of time if I am haha
- The topic ‘Simple MySQL Query’ is closed to new replies.