|
|
Posted by strawberry on 11/21/06 17:38
Jerim79 wrote:
> 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.
SELECT lower(FNAME) lc_fname, lower(LNAME) lc_lname
FROM (table)
WHERE FNAME=('$FName')
AND
NAME=('$LName')
Navigation:
[Reply to this message]
|