|
|
Posted by strawberry on 11/21/06 17:54
Jerim79 wrote:
> 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?
They're just aliases.
SELECT FNAME, lower(FNAME) AS lc_fname, LNAME, lower(LNAME) AS lc_lname
FROM (table)
WHERE FNAME=('$FName')
AND
NAME=('$LName')
is 'NAME' right on the last line?
This should work. Although php is case sensitive, mysql isn't - unless
you include BINARY in the query- so I can't quite see why you need to
do all that stuff.
Navigation:
[Reply to this message]
|