Posted by Jerim79 on 11/21/06 15:44

Jerim79 wrote:
> I am working on a script that will query a database for a FNAME/LNAME
> combo. If it finds the combo, I need it to do one set of instructions.
> If it doesn't find it, I need it to do something else. What I can't
> figure out is what variable to check against. Here is what I have for
> the relevant part of the script:
>
> $connection = mysql_connect($hostname, $username, $password);
> mysql_select_db($databasename) or die ("Cannot connect to database" .
> mysql_error());
> $query="SELECT FNAME, LNAME FROM (table) WHERE FNAME=('$FName') AND
> NAME=('$LName')";
> $result = mysql_query($query) or die('Query failed: ' . mysql_error());
>
> mysql_close($connection);
>
> I tried checking the value of $result to see if it changed depending on
> whether or not it found the selection. It does not. I just can't figure
> out what to use for:
>
> if (some expression){
> perform this code
> }
> else{
> do this
> }

It looks like I need the function $result-> to accomplish this.
However, I am not sure how to use it in my case. Every attempt to use
it results in an error. For instance:

$result = $result->mysql_query($query) or die('Query failed: ' .
mysql_error());

[Back to original message]