Re: [PHP] verify another flavor

2009-03-07 Thread PJ
Paul M Foster wrote: On Fri, Mar 06, 2009 at 10:49:12AM -0600, haliphax wrote: snip I would go about it like this: $sql1 = select concat_ws(' ', first_name, last_name) as Author_Name from author where first_name = '$first_nameIN' and last_name = '$last_nameIN'; If you already know the

Re: [PHP] verify another flavor

2009-03-06 Thread haliphax
On Fri, Mar 6, 2009 at 10:36 AM, PJ af.gour...@videotron.ca wrote: I know I'm a pain the butt but I just can't help asking for help. You guys are so nice... ;-) I am trying to do some checks if there are entries in the db so I can then insert the right stuff. And I'm looking for ways to

Re: [PHP] verify another flavor

2009-03-06 Thread Bastien Koert
$sql1 = SELECT first_name, last_name) FROM author WHERE (first_name LIKE 'first_nameIN' last_nameIN LIKE 'last_nameIN') On Fri, Mar 6, 2009 at 11:36 AM, PJ af.gour...@videotron.ca wrote: I know I'm a pain the butt but I just can't help asking for help. You guys are so nice... ;-) I am trying

Re: [PHP] verify another flavor

2009-03-06 Thread Paul M Foster
On Fri, Mar 06, 2009 at 10:49:12AM -0600, haliphax wrote: snip I would go about it like this: $sql1 = select concat_ws(' ', first_name, last_name) as Author_Name from author where first_name = '$first_nameIN' and last_name = '$last_nameIN'; If you already know the first_name and