[Resolved] There is an easier way i know it....

ldtiw

Hi i had been Using dreamweaver mx to try and create php pages, but have found that they make things harder to understand as a begginer.

But there is one small thing. At the moment to create the nav for a section on my site im calling the link names from the database so that if one was added it would reflect instantly. but ive found one small problem.

I'm using this piece of code to call the cname from the db:

$result = @("SELECT cname FROM countries");
if (!$result) { echo("<p>Error performing query: " . mysql_error() . "</p>"); exit(); }
while ( $row = mysql_fetch_array($result) ) { echo("<a href=\"\">" . $row["cname"] . "</a><br>"); }?>

I know that there is a way I can put all my query's in to a separate .php file to call them from there, but how? I'm needing to use the same thing again to call the cid, hence the empty link.

In dreamweaver it enabled you to create a recordset which contained all the rows.

any help would be grand.

Cheers Danny.

nemonoman

Do this:
$result = @("SELECT cid, cname FROM countries");
while ( $row = mysql_fetch_array($result) ) {
echo("<a href='$row[0]'>$row[1]</a><br>"); }

//$row[0] -- first item from your query
//$row[1] -- second item, etc.

You could take the query, use it to build a separate file, then include that file in your HTML, BUT that's basically 2 extra and nutty steps . Just do the above and keep your code dynamic

ldtiw

Now my next prob!

Thats all working but now how do i filter the results from index.php?cid=# to display the record for the id?

Thanks
Danny

nemonoman

$result = @("
SELECT cid, cname
FROM countries
WHERE cid=$cid");

You'll have to get $cid from the value you GET using
ndex.php?cid=

You might want to get a tutorial on SQL and using PHP and SQL

ldtiw

Its OK!

Thanks for your help. I found a way of using Dreamweaver and manual coding to work side by site.

The Result

There are still a couple of things that i would need a little help with :rolleyes:

Thankyou.
Danny