[Resolved] Sql true query

owaring

i am trying to write a simple query to check whether a field has a certain value in the db.

at the moment the only value that the db will be able to execute the query with is 5

however whether $test = 5 or any other value at all the page always echoes TRUE.

$test = 5;


$idquery = "SELECT * FROM crew WHERE id='$test'";
$result = mysql_query($idquery)
or die ("Couldn't execute crew query.");


if($result == TRUE)
{  

    echo "TRUE"; 
}  

else
{
    echo "FALSE";
}

I'm sure this is a schoolboy error and i hope you sigh at my mistakes!!!

as a side i the book i'm learning from is not very good at explaining how data is returned from an sql query. (I suspect this is what is wrong with this code) If any one can suggest any tutorials or study notes i would appreciate it.

Many thanks

Skull

$test = 5;


$idquery = "SELECT * FROM crew WHERE id='$test'";
$result = mysql_query($idquery)
or die ("Couldn't execute crew query.");
$row = mysql_fetch_array($result);


if($row == TRUE)
{  

    echo "TRUE"; 
}  

else
{
    echo "FALSE";
}

that should work

phil_j_poore

i would use

$rows = mysql_num_rows();
// if last sql query was false then this will be equal to 0
// else it would return the number of rows

so i make the final code....

$idquery = "SELECT * FROM crew WHERE id='$test'";
$result = mysql_query($idquery) or die ("Couldn't execute crew query.");
$rows = mysql_num_rows($result);



if($rows !== 0)
{  

    echo "TRUE"; 
}  

else
{
    echo "FALSE";
}

i hope this helps....

owaring

cheers guys....

i have that sorted now, thanks.

Now i need to work out a way of manipulating the $id string if it matches one in the db.

<?
include("../include/functions.php");

accessdb();

$firstname = oliver;//FORM INPUT
$lastname = waring;

$id1 = substr($firstname,0,3);
$id2 = substr($lastname,0,3);
$formid = ($id1.$id2);//AUTO ID FROM FORM


$idquery = "SELECT * FROM crew WHERE id='$formid'";
$result = mysql_query($idquery)
or die ("Couldn't execute id query.");
$row = mysql_fetch_array($result);// COMPARE FORMID 


if($row == TRUE)
{$id = ($formid.+1);}  //IF MATCH ADD 1
else
{$id = $formid;}//IF NO MATCH ID = FORMID


echo $id;

?>

what i have written adds a 1 to the end of the string, however i found that when you continue with similar entries you get

abcxyz
abcxyz1
abcxyz11
abcxyz111
etc

i want the integer at the end of the string to increase each time ie

abcxyz
abcxyz1
abcxyz2
abcxyz3

any ideas?

Roger_Ramjet

You'll have to cut it off the end of the string if you want to do arithmetis with it. PHP does dynamic typing, you can't do arithmetic with a string so it turns your integer '1' into a string and tacks it on to the end instead.