[SOLVED] getting data from mysql

[fantomel]

Hello i'm trying to get some data from mysql but i run into a problem and i don't know how to fix it please can someone help me ?

 

 

 

function get_bottom_menu() {
    $query = "SELECT * FROM cms_pages WHERE active = 1 ORDER BY position";
    $result = mysql_query($query);
    while($check = mysql_fetch_array($result)) {
    echo "<a href="index.php?page=" . $check['page_id'] . ">" . ['link_name'] "."</a>";
    }


}

[Mchl]

And the problem is?

[fantomel]

And the problem is?

 

sorry forget to post it

 

Parse error: parse error, expecting `','' or `';'' in C:\wamp\www\config\config.php on line 31

[DjMikeS]

Of course you get that error...

 

echo "<a href="index.php?page=" . $check['page_id'] . ">" . ['link_name'] "."</a>";

 

What do you think is wrong with that ?

[fantomel]

Of course you get that error...

 

echo "<a href="index.php?page=" . $check['page_id'] . ">" . ['link_name'] "."</a>";

 

What do you think is wrong with that ?

ooops forget to add ... i've added $check but still same error

[DjMikeS]

What does the error mean ? That you have closed your argument, but failed to close the echo statement...

 

Now where-o-where did I close that argument...hmm

echo "<a href="index.php?page=" . $check['page_id'] . ">" . ['link_name'] "."</a>";

[fantomel]

if i wold see the mistake i think i could remove it but i can't see it cuz i'm running out of time around here and and moving to fast.. doing multiple things in the same time..

[DjMikeS]

The error is so obvious...

Just review the double qoutes in your echo statement...

[fantomel]

echo "<a href=index.php?page=" . $check['page_id'] . ">" . $check['link_name'] . "</a>";

is it ok like this ? didn't had time to test it:-s.

[Mchl]

Not really. It will generate invalid HTML.

Try

 

echo "<a href='index.php?page={$check['page_id']}'>{$check['link_name']}</a>";

[fantomel]

it doesn't make the echo on the page.. i used get_bottom_menu(); in the place where i want to generate it.

[DjMikeS]

You're getting close...

 

Your php is well formed, but you HTML is not...

http://www.w3schools.com/HTML/html_links.asp

 

You solve it in three ways:

1. escape the needed double qoutes inside your argument:

echo "<a href=\"index.php?page=" . $check['page_id'] . "\">" . $check['link_name'] "."</a>";

2. use single qoutes for your html:

echo "<a href='index.php?page=" . $check['page_id'] . "'>" . $check['link_name'] "."</a>";

3. use single qoutes for your echo statement:

echo '<a href="index.php?page=' . $check['page_id'] . '>' . $check['link_name'] '.'</a>';

 

At last: you may use variables in echo statements.

So probably the best would be:

echo "<a href=\"index.php?page=$check['page_id']\">$check['link_name']</a>";

 

Which should run fine...

[fantomel]

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in C:\wamp\www\config\config.php on line 31

for

echo "<a href=\"index.php?page=$check['page_id']\">$check['link_name']</a>";

and for the rest it gives the same error.. from the beginning.

[DjMikeS]

Try the curly brackets as Mchl mentioned....

[fantomel]

i've already did that.. on var_dump works it's getting the data from sql the problem is from the echo statement .

[DjMikeS]

Are you sure that this echo statement is on line 31?

[fantomel]

Yes i'm sure.. but i've solved the problem.. made  the code without function i placed it where i wanted.