|
|
Posted by Jerim79 on 11/21/06 17:49
strawberry wrote:
> 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')
I tried that and it didn't seem to work. I am converting my FName and
LName as they are posted from the form page.
$FName=strtolower($_POST["$FName"])
That seemed to work, as valid data was returning negative results
before making the changes you suggested. So now I just need to get the
SQL results into lower case. I am curious as to lc_fname and lc_lname.
Are those new variable names that I should check against or do they
replace FNAME automatically?
Navigation:
[Reply to this message]
|