Can someone help me with this?

[salukigirl]

Ok, long story short I'v having trouble with my output. It output's well.... nothing....


This is the pet store page. It creates the animal the user wants. When it is done it is to store the bought pet at the owner's home page. But for some reason it doesn't show up.....
Am I like missing a huge chunk of code? or???
Here are the scripts I built...

<?php
include ('connect.php');
?>

<form name="form1" method="post" action="petstore.php">
Registered Name:
<br>
<input name="petname" type="text"
Rabbit Breed:
<select breed="petbreed"
<option value="American Chinchilla">American Chinchilla</option>
<option value"American Fuzzy Lop">American Fuzzy Lop</option>
<option value"American Sable">American Sable</option>
<option value"Belgian Hare">Belgian Hare</option>
<option value"Brittania Petite">Brittania Petite</option>
<option value"Californian">Californian</option>
<option value"Champagne D'Argent"> Champagne D'Argent </option>
<option value"Checkered Giant">Checkered Giant</option>
<option value"Cinnamon">Cinnamon</option>
<option value"Creme D'Argent">Creme D'Argent</option>
<option value"Dutch">Dutch</option>
<option value"Dwarf Hotot">Dwarf Hotot</option>
<option value"English Angora">English Angora</option>
<option value"English Spot">English Spot</option>
<option value"Flemish Giant">Flemish Giant</option>
<option value"Florida White ">Florida White </option>
<option value"Giant Angora">Giant Angora</option>
<option value"Giant Chinchilla ">Giant Chinchilla </option>
<option value"French Angora">French Angora</option>
<option value"Harlequin">Harlequin</option>
<option value"Havana">Havana</option>
<option value"Himalayan">Himalayan</option>
<option value"Holland Lop">Holland Lop</option>
<option value"Hotot">Hotot</option>
<option value"Mini Rex">Mini Rex</option>
<option value"Rex">Rex</option>
<option value"Satin Angora">Satin Angora</option>
<option value"Standard Chinchilla ">Standard Chinchilla </option>
<br>
pet gender:
<select name"petgender">
<option value"male">Male</option>
<option value"female">Female</option>
<br>
Pet Color:
<select name"petcolor">
<option value"white">White</option>
<option value"black">Black</option>
<option value"gray">Gray</option>
<br>
</select>
<input type="submit" name="submit" value="But It!">
</form>

<?php
$petname = trim($_POST['petname']);
$petbreed = trim($_POST['petbreed']);
$petgender = trim($_POST['petgender']);
$petcolor = trim($_POST['petcolor']);
?>

<?php
$ownerid =$_SESSION['id']
?>

<?php
$pet =@mysql_query("INSERT INTO pets (ownerid, petname, petbreed, petgender, petcolor) 
VALUES ('$ownerid', '$petname', '$petbreed', '$petgender', '$petcolor')") or die ("error:".mysql_error())
?>

This is the Home page. I want it to display the animal the user just bought.

<?php
include('connect.php'); 
?>

<?php
$query="SELECT petname, petbreed, petgender, petcolor FROM pets WHERE ownerid=".$_SESSION['id']."";
$result = mysql_query ($query)
or die ("couldn't execute query.");
?>

<?php
while ($pet= mysql_fetch_object ($result))
{
?>



<?php
echo
"
Registered Name: $petname
<br>
Breed: $petbreed
<br>
Gender: $petgender
<br>
Color: $petcolor
<br><br>
";
?>
<?php
}
?>

[Slothie]

<input name="petname" type="text">
Rabbit Breed:
<select breed="petbreed"> 

[salukigirl]

Thanks... that helped but. it still doesn't show the name, breed, gender, and color of the rabbit you bought...

[Slothie]

Echo out your query. Chances are its not inserting properly.

[salukigirl]

I have the echo in there. Did I do it wrong? Is it in the right place?

[toofani]

I have the echo in there. Did I do it wrong? Is it in the right place?

i guess check this:
<?php
include('connect.php');
?>

<?php
$query="SELECT petname, petbreed, petgender, petcolor FROM pets WHERE ownerid=".$_SESSION['id']."";
$result = mysql_query ($query)
or die ("couldn't execute query.");
?>

<?php
while ($pet= mysql_fetch_object ($result))
{
?>



<?php
echo
<br>
Registered Name: $petname
<br>
Breed: $petbreed
<br>
Gender: $petgender
<br>
Color: $petcolor
<br><br>



is this the output you want?
Registered Name: $petname
Breed: $petbreed
Gender: $petgender
Color: $petcolor

[Slothie]

I meant echo

"INSERT INTO pets (ownerid, petname, petbreed, petgender, petcolor) 
VALUES ('$ownerid', '$petname', '$petbreed', '$petgender', '$petcolor')" 

out

[conker87]

You're not suppling the values to the variables.

<?php
include('connect.php'); 

$query="SELECT petname, petbreed, petgender, petcolor FROM pets WHERE ownerid=".$_SESSION['id'];
$result = mysql_query ($query) or die ("couldn't execute query.");

while ($pet= mysql_fetch_object ($result))
{

echo "Registered Name: ". $pet['petname'] ."
<br>
Breed: ". $pet['petbreed'] ."
<br>
Gender: ". $pet['petgender'] ."
<br>
Color: ". $pet['petcolor'] ."
<br><br>";

}
?>

Cleaned up slightly too.

[salukigirl]

You're not suppling the values to the variables.

<?php
include('connect.php'); 

$query="SELECT petname, petbreed, petgender, petcolor FROM pets WHERE ownerid=".$_SESSION['id'];
$result = mysql_query ($query) or die ("couldn't execute query.");

while ($pet= mysql_fetch_object ($result))
{

echo "Registered Name: ". $pet['petname'] ."
<br>
Breed: ". $pet['petbreed'] ."
<br>
Gender: ". $pet['petgender'] ."
<br>
Color: ". $pet['petcolor'] ."
<br><br>";

}
?>

Cleaned up slightly too.

That's what I was thinking! -smacks self and feels stupid. I didn't save that info into the varibles.
Thanks so much! :drool:
Edit:
Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/star/public_html/bunnygame/home.php on line 10

? =(

[conker87]

What is line 10?

Oh wait, I've never used fetch object. Try this:

Edit: Try this newer one, here's me trying to make an echo look cleaner -.-

<?php
include('connect.php'); 

$query="SELECT petname, petbreed, petgender, petcolor FROM pets WHERE ownerid=".$_SESSION['id'];
$result = mysql_query ($query) or die ("couldn't execute query.");

while ($pet= mysql_fetch_array($result))
{ ?>
Registered Name: <?=$pet['petname']; ?><br>
Breed: <?=$pet['petbreed']; ?><br>
Gender: <?=$pet['petgender']; ?><br>
Color: <?=$pet['petcolor']; ?><br><br>";
<? } ?>