up vote 0 down vote favorite
1

I seem to be having trouble with my php code. I have constructed the query using phpMyAdmin where it works without any problems. However, once I insert the sql query into this php code it does not seem to work at all.

<?php
define('dbname',"dbname");
define('dbusername',"dbusername");
define('dbpass',"pass");
define('dbhost','10.10.10.1'); 

mysql_connect(dbhost,dbusername,dbpass);

    echo  "Connected to MySQL<br>";

    mysql_select_db(dbname);

    echo "Connected to Database<br>";

$q=mysql_query("SELECT * FROM tube WHERE code = B");

while($row=mysql_fetch_assoc($sql))
       $output[]=$row;

print(json_encode($output));

mysql_close();

?>

I keep getting the following error message when I try and execute the php script using my web browser.

HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while the server was attempting to fulfil the request.

Any help regarding the coding would be helpful. Also the primary key is set to auto incremental if that makes any difference?

Thanks

share|improve this question
this will be due to your script and not the query itself. 500 error code pretty much means the page could not be loaded. Since your connection is obviously local development, I would start checking there to make sure you're even communicating with the DB. – Kai Qing Nov 2 '11 at 1:55
You're best bet is to look at the apache logs and see if there's any more information in there. – hafichuk Nov 2 '11 at 1:55
The mysql extension is outdated and on its way to deprecation. New code should use mysqli or PDO, both of which have important advantages, such as support for prepared statements. Don't use SELECT * unless you're writing a DB administration program; select only the columns you need. – outis Mar 29 '12 at 1:32
<br/> is rarely semantic; use something more appropriate, such as a paragraph or list element. – outis Mar 29 '12 at 1:33

closed as too localized by Jeremy Banks, xdazz, mario, outis, Matt Mar 29 '12 at 8:33

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, see the FAQ.

1 Answer

up vote 0 down vote accepted

There is no such function as sql_query, you mean mysql_query. You're also using two different variables in your loop.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.