Jump to content

PHP & MySQL - should be simple


rockonxox

Recommended Posts

I have a database of all the horses I own. All I want to do is list them on my site and have their name linked to their ID# in the database. When their name is clicked, I want information to be shown based on that ID#. How should I go about this?

I am thinking I need a second page with how I want the horse information to be shown. Am I correct in thinking this and if so how should I set it up?

The horses id is 'hid' in the database.
Link to comment
Share on other sites

Yeah, it's easiest to create a second page. For instance, your first page could be "allmyhorses.php" and the second page "horsedetail.php".

On the first page, you create some links like this:
[code]<a href='horsedetail.php?id=5'>Horse 5</a>[/code]
and on the second page ("horsedetail.php"), you check the form input and retrieve some data, like this:
[code]$horseid = $_GET['id'];
... SELECT * FROM horsedatabase WHERE id='$horseid' ...[/code]
Link to comment
Share on other sites

[code]
$sql = mysql_query("SELECT * FROM horses order by id");

if (mysql_num_rows($sql) > 0) {
    while($row  = mysql_fetch_object($sql)) {
        echo "$row->id<br>";
        echo "$row->name<br>";
        echo "<a href=\"details.php?id=$row->id\">More Info</a><br><br>";}
}
[/code]

Something like that for the list would be good. Basically, It would search you database table named Horses and order them by ID number. It would then list then like this.

ID
NAME
MORE INFO

ID...etc

For details.php...

youd want a query like..

[code]
$horseid = $_GET['id']
$sql = mysql_query("SELECT * FROM horses WHERE id='$houseid'");

if (mysql_num_rows($sql) > 0) {
    while($row  = mysql_fetch_object($sql)) {
        echo "$row->id<br>";
        echo "$row->name<br>";
        echo "$row->ANY OTHER ROWS YOU WANT TO SHOW";}
}
[/code]

that would basically be what you wanted
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.