Re: [PHP] Select and compare problems still ...

2009-07-01 Thread Miller, Terion
On 7/1/09 10:29 AM, "Andrew Ballard" wrote: $data = array($ucName, $ucAddress, $inDate, $inType, $notes, > $critical, $cleanViolations, $noncritical); > > $sql = vprintf("INSERT INTO `restaurants` (name, address, inDate, > inType, notes, critical, cviolations, noncritical) VALUES ('%s', '%s',

Re: [PHP] Select and compare problems still ...

2009-07-01 Thread Andrew Ballard
On Wed, Jul 1, 2009 at 11:23 AM, Andrew Ballard wrote: > On Wed, Jul 1, 2009 at 10:56 AM, Miller, > Terion wrote: >> Why doesn't this work? >> >> >>    $query = "SELECT * FROM `restaurants` WHERE name ='$ucName' AND >> address = '$ucAddress'  " ; >> >> $result = mysql_query($query) or die(mysql_err

Re: [PHP] Select and compare problems still ...

2009-07-01 Thread Miller, Terion
On 7/1/09 10:06 AM, "Phpster" wrote: On Jul 1, 2009, at 10:56 AM, "Miller, Terion" wrote: > Why doesn't this work? > > >$query = "SELECT * FROM `restaurants` WHERE name ='$ucName' AND > address = '$ucAddress' " ; > > $result = mysql_query($query) or die(mysql_error()); > > > echo

Re: [PHP] Select and compare problems still ...

2009-07-01 Thread Andrew Ballard
On Wed, Jul 1, 2009 at 10:56 AM, Miller, Terion wrote: > Why doesn't this work? > > >    $query = "SELECT * FROM `restaurants` WHERE name ='$ucName' AND > address = '$ucAddress'  " ; > > $result = mysql_query($query) or die(mysql_error()); > > >  echo $result; >     $row = mysql_fetch_array ($resul

Re: [PHP] Select and compare problems still ...

2009-07-01 Thread Phpster
On Jul 1, 2009, at 10:56 AM, "Miller, Terion" > wrote: Why doesn't this work? $query = "SELECT * FROM `restaurants` WHERE name ='$ucName' AND address = '$ucAddress' " ; $result = mysql_query($query) or die(mysql_error()); echo $result; $row = mysql_fetch_array ($result); $s

[PHP] Select and compare problems still ...

2009-07-01 Thread Miller, Terion
Why doesn't this work? $query = "SELECT * FROM `restaurants` WHERE name ='$ucName' AND address = '$ucAddress' " ; $result = mysql_query($query) or die(mysql_error()); echo $result; $row = mysql_fetch_array ($result); $sql = "INSERT INTO `restaurants` (name, address, in