Selecting from table

Space Cowboy · 06-06-2005

Ok im back again, im trying to make a script select a value from "Race" in my SQL database when given the username. I've bein trying to work it out for my self but so far im useless with SQL Querys

Code:

//SQL Querys
$sql = "SELECT * FROM $login_table WHERE username = '$username' AND Race";

Will ^^^ That code select the Race from the table givven the Username!

Then last bit here i want to make it output something Like this, where if the race = human it tells flash race is o and sends the race back to flash!

Code:

IF $Race=Human 

echo "checkrace=good"; 
echo "race=$race";
else

echo "checkrace=bad";

ParaSnake · 06-06-2005

In fact,i dont understand what u are talking about SCB

Could u make it clearer,so that i can help u

Space Cowboy · 06-06-2005

OK sorry bout that iv bein working on this and if created this script

Code:

<?php
//Database Connectivity Variables//
$DBhost = "localhost";
$DBuser = "joj_test";
$DBpass = "test";
$db_name = "joj_stargate";
$login_table = "Finnal_Users"; 
//Create a connection to the MySQL Database//
$connection = @mysql_connect($DBhost,$DBuser,$DBpass) or die("Couldn't Connect.");
$db = @mysql_select_db($db_name, $connection) or die("Sorry, I could not select the requested Database ");
$query = "SELECT * FROM $login_table WHERE Username = '$username'";
    $result = mysql_query($query);
    
    while($row = mysql_fetch_array($result)){
		$Race = $row["Race"];
echo 'status=$Race';
exit;
}
?>

What i want it do do its fetch the race from the SQL table so if say user X loges in then runs this script the php searched for user X's Race then displays the race! The script iv got above doesnt seam to work right all i get in my output value is "$race" and no "Human" Which is what shoud come out for that user!

Im finding this hard to explain so i've uploaded a picture i want to loadinto flash useing echo the race of a user so i tried the above script but when i tested it instead of getting "Asgard" in the status bar i got "$Race" SO im guessing iv done something wrong!

ParaSnake · 06-06-2005

Ur nice pic says it all

so what u want is to do a mini function that will show the user`s race each time he/she logged in,rite?

PHP Code:


			
//assume that X has logged in and his username is store in $logged_username

//user is a table that store ur user`s informations

$a=mysql_query("SELECT * FROM user WHERE username='".$logged_username."' ")or die("problem with db");

//fetch the $a

$user_info=mysql_fetch_assoc($a);

//give the $race the user`s race value

$race=$user_info["race"];

//output it

echo $race;

That is what u have to to,thx God that i still remember PHP`s structure,i almost forgot it :P

ParaSnake · 06-06-2005

I read through ur codes and i realized that u have sth wrong with ur syntax

this is wrong:

PHP Code:


			
$query = "SELECT * FROM $login_table WHERE Username = '$username'";

and this is right:

PHP Code:


			
$query="SELECT * FROM $login_table WHERE username = '".$username."' ";

That`s why ur script doesnt work

And after that i suggest u should recheck the username using "mysql_num_rows" to make sure its is a legal username

Space Cowboy · 06-06-2005

I changed a few things around but the script works very nicely again i thank you for you're help here!

Edit im using the first script you suggested and its running perfectly!