|
|
Posted by Jerim79 on 11/21/06 21:47
Shelly wrote:
> "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
Thak you for the help. I didn't have to format the MySQL data after
all. The data stored in the database had capital letters. However, my
correct data returns true no matter how I capitalize it. The wrong data
returns false. So it just seems to work. I didn't have to make any
change to the MySQL query at all. I appreciate your help on getting the
$_POST variables to lower case and
Navigation:
[Reply to this message]
|