A script of mine

phpnoobguy

Can someone guide me in the right direction. I'm writing a very small online pet game in php. When you go to the home its supposed to tell you your active pet but how can i grab that out the MySql db and print it?

bubblenut

Well, the first step in a situation like this is to describe your problem in the vaguest possible way and then post it on a forum. This you have done very well. The next step is to wait untill somone points out how vague your question is and then ask it properly, stating exactly what the problem is: what you're trying to do, how you're trying to do it and what's going wrong.

phpnoobguy

What exactly the problem is: I want to know how to grab a piece of imformation out of my db and put it in a variable ie.

$name = "code to grab out db"

bubblenut

You're still being incredibly vague. What database management system are you using (MySQL, Postgres etc), what's the strucutre of the database? If you're using MySQL and all you're looking for are the functions to interact with the database then take a look in the manual, get a rough idea of what's going on and then post back here to clear up any details.

move3rd

Originally posted by phpnoobguy
What exactly the problem is: I want to know how to grab a piece of imformation out of my db and put it in a variable ie.

$name = "code to grab out db"

Why not read some tutorials on the subject:
http://hotscripts.com/PHP/Tips_and_Tutorials/Database-Related/index.html

phpnoobguy

I'm using MySql and I want it to display the users active pet and user when they log in on every page at the side.

EDIT: and put it in a varible so i can display it when i need it. This is the db structure for the pet table. Big code coming!

Table structure for table `petgamex_pets`

CREATE TABLE petgamex_pets (
id int(3) NOT NULL auto_increment,
name varchar(12) NOT NULL default 'You don''t ha',
power int(3) NOT NULL default '0',
defence int(3) NOT NULL default '0',
wisdom int(3) NOT NULL default '0',
speed int(3) NOT NULL default '0',
hit_points int(3) NOT NULL default '0',
image_path longtext NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

Dumping data for table `petgamex_pets`

INSERT INTO petgamex_pets VALUES (1, 'Chaos', 3, 3, 3, 3, 10, 'http://www.blueflameheaven.com/petgamex/images/pets/pet1.gif');