Query Was Empty::: now what did I do wrong?

[elite_prodigy]

$get_url = 'SELECT * FROM `main_nav`; LIMIT 0, 30 ';

$get_url_res = mysql_query($get_articles,$conn) or die(mysql_error());

 

 

 

while ($url_array = mysql_fetch_array($get_url_res)) {

$url = $url_array;

$value = $url_array[value];

 

$display_url .= "<a href=\"$url\"> $value </a><br/><br/>";

}

 

echo $display_url;

 

I simply wanted to test whether or not this was outputting correctly before implementation, but it is not working. I keep getting a querry was empty message where there is stuff in that table!

 

So, can someone tell me whats wrong? Please?  :'( :'(

[trq]

Your query is stored within the $get_url variable yet your parsing $get_articles to mysql_query.

 

When you get there, your query has a syntax error also. Should be....

 

$get_url = 'SELECT * FROM main_nav LIMIT 0, 30';

[marklarah]

try

 $display_url = '<a href="'.$url.'">'.$value .'[/url]';

 

 

[elite_prodigy]

Your query is stored within the $get_url variable yet your parsing $get_articles to mysql_query.

 

When you get there, your query has a syntax error also. Should be....

 

$get_url = 'SELECT * FROM main_nav LIMIT 0, 30';

 

Thanks!!!

 

I knew it was something so simple.

I've been copy/pasting code from one section of my site to another because every thing works on the same principle with just a bit of editing. (guess I should have loooked closer!)

 

Thanks again!

 

You guys/girls are awsome!

Ausgehtzeichet!