|
|
Posted by Jerim79 on 11/21/06 17:28
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.
Navigation:
[Reply to this message]
|