|
|
Posted by Shelly on 11/21/06 19:01
"Jerim79" <mylek@hotmail.com> wrote in message
news:1164130117.634974.266300@m7g2000cwm.googlegroups.com...
>
> Shelly wrote:
>> "Jerim79" <mylek@hotmail.com> wrote in message
>> news:1164124743.834016.303130@m73g2000cwd.googlegroups.com...
>> >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
>> > }
>> >
>>
>> $numRows = mysql_num_rows($result);
>>
>> then test on whether $numRows is greater than zero.
>>
>> Shelly
>
> Thanks, that worked perfectly. Now I need to take the first name and
> the last name out of the query result and convert them to lower case. I
> understand there is a PHP function for lower case. My question is how
> to access specific columns in the result.
$row = mysql_fetch_assoc($result);
$lastName = strtolower($row['LNAME']);
$firstName = strtolower($row'FNAME']);
Shelly
Navigation:
[Reply to this message]
|