Search results

got my probem solved thnx for the help.

pettable is for when the pets are registered. when pet are registered it takes the oringal stats(atk,def) from this table and updates it into pets table which is the table the users pets are in. these two tables have to be different becuase the users can upgrade their stats but when new people...

pet id is number in what the species is in pettable but pettalbe has it petnum instead. so petid 1 is = to petnum 1. that way when i have multiple pets and want to echo it in their profile i can do the color of image easier. like pet num 1 is red, pet num 2 is blue version etc.

users can have more than 1 pet. user table contains all information about real life user information. table pets contain information of user pets and their stats. petstable contains the basic stats and the image to the pet such as attack when you first create it id 1|Dragon|atk 4 |def...

k here we go. i know some of the data types are wrong. but these are the tables i need joined. users table CREATE TABLE `users` ( `user_id` bigint(100) NOT NULL auto_increment, `user_name` varchar(65) NOT NULL, `user_password` varchar(65) NOT NULL, `user_email` varchar(65) NOT...

these are the 3 tables i want to join and need to be able to echo out all the information at differnt times. $sql = 'SELECT * FROM `users` WHERE 1 LIMIT 0, 30 '; $sql = 'SELECT * FROM `pets` WHERE 1 LIMIT 0, 30 '; $sql = 'SELECT * FROM `pettable` WHERE 1 LIMIT 0, 30 ';

how do i get the create table structure if i did it in phpmyadmin?

Making a profile for the user whos logged in for a virtual pet site. i have the log in already and the user set to $user. i need all information from 3 differnt tables for the profile of the current user. One table has the user information called "users"(contains...

trying to make profile page which displays information from 3 differnt table using full join for the current user thats logged in which is in the variable $user. need to select table 'users' to get their info and than connect users to the table 'pets' for pet information and the petid...

thnx got my problem solved now

currently have fetch_array is a invalid arugment on line 32 if anyone knows how to fix this

Trying to make pet registration form. When i choose color/gender/name than click register it sends the pet information to the table. But for the second part i cant figure out why it comes up with error fetch_aray is a invalid argument. confirm.php has my connecting information and its all...

yup sorry forgot to say it. problem soleved ;)

Having problems trying to get 3 differnt values into one field(birthday,birthmonth,birthyear) found out i cant assign more than one value to variable like this and wondering if and how i can set this into array. this outputs nothing and when i give them differnt varables and try to put it...

I have a registration for age where they have to choose month, choose day, and type in the year. i got 1 field for age. Question 1: can i store all values into that field like day, month, year? Question 2: if i wanted to echo out the birthday of the person and than age above it can i pull out...

added the if statement and changed url but it gives me the 404 error

Having problems outputing information from a table called login. Database information is correct and users are in there under field 'username' .Noticed everyone's opinions on whats wrong with code havnt worked so far. Output is always User profile which is direct text in the head. When signed...

hmm still not working, replacecd it with username to.

it says User Profile like i have in head. When not loged in the java script works and redirects me to main page so nothing wrong with that but i need to get data from a table for a profile. But nothing happens when i echo it out.

trying to grab data from table and than echo it out in profile but its not working or if anyone has better profile way they like to help me with <? $user = $_GET['user']; session_start(); if(isset($_SESSION['user'])){ } else { echo " <script language='javascript'> alert('Sorry, but...