Re: SQL: Limit 1 usage?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hmm, I trried your syntax and same problem.  

I tried it exactly like this:  (though i'd like to stress that it worked with the code labeled ORIGINAL below)


<?php


$connection = mysql_connect("********","*****","*********")
or die("Couldn't make connection...because I hate you.");


$db = mysql_select_db("national", $connection)
or die("Couldn't select database.");


$sql = "SELECT * FROM accessnums WHERE areacode='{$_POST['areacode']}' and
city='{$_POST['cityselected']}' ORDER BY network LIMIT 1";


// ORIGINAL $sql = "SELECT * FROM accessnums WHERE areacode='$_POST[areacode]' and city='$_POST[cityselected]' ORDER BY network LIMIT 1";

//  WORKS just needs tweaking: SELECT * FROM accessnums WHERE areacode="318" and city="monroe" ORDER BY network LIMIT 1;


$sql_result = mysql_query($sql,$connection)
or die("Couldn't execute query.");
   

while ($row = mysql_fetch_array($sql_result)) {

$network = $row["network"];
$areacode = $row["areacode"];
$cityselected = $row["cityselected"];

}



if ($network == 1):
    echo "<p>This customer is on network: <font size=\"4\">A</font>.  This is Bayou Internet's network.<br>They should  download Dialer A at: <a href=
\"http://www.bayou.com/dialer/dialer.exe\";>http://www.bayou.com/dialer/dialer.exe</a></p>";
elseif ($network == 2):
    echo "<p>This customer is on network: <font size=\"4\">B</font>.  This is Surf.net's network.<br>They should download Dialer B at: <a href=\"http://www.bayou.com/dialer/dialer-b.exe\";>
http://www.bayou.com/dialer/dialer-b.exe</a></p>";
elseif ($network == 3):
    echo "<p>This customer is on network: <font size=\"4\">B</font>.  This is Surf.net's network.<br>They should download Dialer B at: <a href=\"http://www.bayou.com/dialer/dialer-b.exe\";>
http://www.bayou.com/dialer/dialer-b.exe</a></p>";
elseif ($network == 4):
    echo "<p>This customer is on network: <font size=\"4\">E</font>.  This is Dual.usa / @usa's network.<br>They  should download Dialer E at: <a href=\"http://www.bayou.com/dialer/dialer-
e.exe\">http://www.bayou.com/dialer/dialer-e.exe</a></p>";
elseif ($network == 5):
    echo "<p>This customer is on network: <font size=\"4\">C</font>.  This is Pop.net's network.<br>They should download Dialer C at: <a href=\"http://www.bayou.com/dialer/dialer-c.exe\";>
http://www.bayou.com/dialer/dialer-c.exe</a></p>";
elseif ($network == 6):
    echo "<p>This customer is on network: <font size=\"4\">D</font>.  This is World.net's network.<br>They should download Dialer D at: <a href=\"http://www.bayou.com/dialer/dialer-d.exe\";>
http://www.bayou.com/dialer/dialer-d.exe</a></p>";
else:
    echo "There has been a data error.  This is most likely the programmer's fault.  Blame funding.  <a href=\"http://www.bayou.com/dialer/admin/numbercheck.php\";>Ignore and try again.</a>";
endif;


mysql_free_result($sql_result);
mysql_close($connection);

?>











1/30/2003 3:51:15 PM, "Ignatius Reilly" <ignatius.reilly@free.fr> wrote:

>Doubly wrong PHP syntax.
>
>Try instead:
>$sql = "SELECT * FROM accessnums WHERE areacode='{$_POST['areacode']}' and
>city='{$_POST['cityselected']}' ORDER BY network LIMIT 1";
>
>Ignatius
>____________________________________________
>----- Original Message -----
>From: "jason wesley upton" <upton@bayou.com>
>To: <php-db@lists.php.net>
>Sent: Thursday, January 30, 2003 9:42 PM
>Subject:  SQL: Limit 1 usage?
>
>
>> Currently I have a script that contains this piece of code:
>>
>>
>> $sql = "SELECT MIN(network)
>> AS 'network' FROM accessnums WHERE areacode='$_POST[areacode]' and
>city='$_POST[cityselected]'";
>>
>>
>> This works fine and accomplishes what I need.  Some requirements changed
>today and I now need to get more than just "network".  In MySQL command line
>I tried this:
>>
>> SELECT * FROM accessnums WHERE areacode="504" and city="New Orleans" ORDER
>BY network LIMIT 1;
>>
>> This gives me the exact response I require.  However, when plugging it
>into my php code:
>>
>> $sql = "SELECT * FROM accessnums WHERE areacode=$_POST[areacode]' and
>city='$_POST[cityselected]' ORDER BY network LIMIT 1";
>>
>> It can't execute the query.  Any suggestions?
>>
>>
>>
>>
>> Jason Wesley Upton - Web Design / Development - Application Development









-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux