[SOLVED] A Little Help index.php?Page=Home

[ow-design]

Hi,

 

Okay i am struggling with this one as a PHP newby, I can get information from a database using id?=(numeric figure)

 

but how do i call from a database using a title.

 

I have for example a table with the following columns, title, Content, Added

 

how can i get information from a row with an address such as.

 

www.site.com?page=Home

 

Thank You,

Ollie

[wildteen88]

As you normally would do. The extreme basics would be

 

$title = $_GET['page'];
$sql = "SELECT * FROM your_table WHERE title='$page'";
$result = mysql_query($sql);

$row = mysql_fetch_assoc($result);

echo '<pre>'.print_r($row, true).'</pre>';

[Maq]

You mean?

 

$title = $_GET['page'];
$sql = "SELECT * FROM your_table WHERE title='$title'";

[wildteen88]

You mean?

 

<?php
$title = $_GET['page'];
$sql = "SELECT * FROM your_table WHERE title='$title'";

Woops, My bad

[ow-design]

Right so that is displaying the entire row, So what is i just want to display information in diffent places of the webpage?

 

If i do a php echo that is not working???

[sam06]

You have to select each part, like this:

$result = mysql_query("SELECT item FROM table WHERE title='$title'") or die(mysql_error());

$item = mysql_result ($result, 0, 'item');

 

Let item be whatever value you need.

Then echo $item

[wildteen88]

You have to select each part, like this:

$result = mysql_query("SELECT item FROM table WHERE title='$title'") or die(mysql_error());

$item = mysql_result ($result, 0, 'item');

 

Let item be whatever value you need.

Then echo $item

You don't need to do that.

 

mysql_fetch_assoc returns an associative array of columns. Just save each item of the array to a variable. Then do what ever you want with the variables.

 

$row = mysql_fetch_assoc($result);

$title = $row['title'];
$content = $row ['content'];

echo '
<h1>'.$title.'</h1>
<p>'. $content . '</p>
';

[ow-design]

okay i dont know what i am doing wrong but this is not working...

 

Would you be able to give me a complete code... To connect to a database to select from a table called pages and looking for the ?page=

 

and the code i need to pick the title, content and author from the table row and display them individually.??

 

Really appreciate any help.

Thank You

[revraz]

No, but you can paste your code and we can try to tell you what you are doing wrong.

[Maq]

Would you be able to give me a complete code...

 

Have you even attempted to do anything?  There's millions of tutorials on how to connect to a DB.  Once you do that it's easy.

[wildteen88]

okay i dont know what i am doing wrong but this is not working...

 

Would you be able to give me a complete code... To connect to a database to select from a table called pages and looking for the ?page=

 

and the code i need to pick the title, content and author from the table row and display them individually.??

 

Really appreciate any help.

Thank You

I'm not here write scripts for you. I'm here to help/guide you.

 

You said earlier

I can get information from a database using id?=(numeric figure)

With that being said, you should know how to pull data from a databased on any type of column.

[ow-design]

Its okay i have orked this out now, thankyou for all your help

[Maq]

Your welcome... topic solved then?