da(code)da

i have a list and mysql table. my goal is to make the links active if there is a game in its section: this is my code: mysql_select_db("my_db", $con); $result = mysql_query("SELECT * FROM gameChart"); $row = mysql_fetch_array($result); echo "<dl><dt>Writer's Forge</dt>"; if (!$row["secID"] == 1){ echo "<dd>Collaborated Poetry</dd>";} else { …

Im getting a "Unknown database 'user_admin'" error and i dont see it here is my code $username = mysql_real_escape_string($_POST["Username"]); $query = "SELECT * FROM user WHERE UserName='$username'"; $result = mysql_query($query); if(mysql_affected_rows() == 0) { //All Checks Out: Create Databases $dbase = "user_" . $_POST["Username"]; mysql_query("CREATE DATABASE $dbase",$con) or die(mysql_error()); mysql_select_db($dbase, …

My Table create is giving me problems. i probably missed something small but i cant find it. $dbase = $_COOKIE['ID'] . "char"; // Create table mysql_select_db($dbase, $con); $sql = "CREATE TABLE games ( gameID int NOT NULL AUTO_INCREMENT, PRIMARY KEY(gameID), gameName varchar(25), intro TEXT, bground TEXT, cast ENUM( '0', '0', …

Ok I have a promblem. Im getting a unidentified variable error from **$found:** Whats wrong here? while($row = mysql_fetch_array($result)) { **$found** = true; echo "Character/Alias: " . $row["CharName"] . "<br>Created: " . $row["CharBorn"] . "<br>Game: "; if ($row["CharGame"] == '0') { echo "None"; } else { echo "In-Game"; } } …

here my username is know as callsign there is a problem somewhere that i cant find and i present the code: $callsign = mysql_real_escape_string($_POST["CallSign"]); $result = mysql_query("SELECT * FROM users WHERE CallSign = '$callsign'"); $row = mysql_fetch_array($result); echo $row['CallSign'] . "<br>"; $sql = "SELECT COUNT(*) FROM users WHERE CallSign = …

my code is messing up. help: if (mysql_query("CREATE DATABASE $dbname",$con)) { echo "Database Created<br>"; $dbase = $_POST["CallSign"]."char"; mysql_select_db($dbase, $con); $sql = "SELECT * FROM $dbase"; $result = mysql_query($sql); if ($result) { echo "CallSign Accepted<br>"; mysql_select_db("my_db", $con); $sql="INSERT INTO users ( CallSign, Email, FirstName, MiddleName, LastName, Gender, BirthMonth, BirthDay, BirthYear, Location, …

So im trying to make a password login and im getting errors. i got past my Unable to jump to row 0 error with this: **mysql_num_rows($result) >= 1** but now it wont jump to the row when the password is correct ether :/ here is the code; whats wrong with …

Im not seeing it but its not working here is the code: mysql_select_db("my_db", $con); $sql = "CREATE TABLE stream ( waveID int NOT NULL AUTO_INCREMENT, PRIMARY KEY(gameID), userID int, wave varchar(25), waveTime TIMESTAMP DEFAULT NOW() )"; // Execute query if(!mysql_query($sql)) { echo "Couldn't do it"; } else { echo "alright"; …

How to retrieve these feeds and display them on my web site?

Please help I have been trying to insert a timestamp field into a DB. But to no avail. Here's my code. I am using a hidden field. <input type="hidden" value="<? echo date("m-j-y g:i:s A"); ?>" name="time" /> Then on my action page, I do the following. $stime=$_POST['time']; then my insert …