Re: SQL: Limit 1 usage?
| From: | jason wesley upton | Date: | Thu, 30 Jan 2003 22:11:56 +0000 |
| Subject: | Re: SQL: Limit 1 usage? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25277@lists.php.net to get a copy of this message | ||
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: [PHP-DB] 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