SELECT not working

[The Little Guy]

Why does this:

<?php
$function = $_GET['function'];
$query = "SELECT * FROM `functions` WHERE `function` = 'random' LIMIT 1";
$sql = mysql_query($query);
?>

 

only return a result if all fields are filled in, in the database for that record?

[wildteen88]

You are limiting the query to return only 1 result. This is why you are getting only one result. Remove LIMIT 1 from the query.

[cooldude832]

is function a integer?

[The Little Guy]

You are limiting the query to return only 1 result. This is why you are getting only one result. Remove LIMIT 1 from the query.

Still can not find it

 

is function a integer?

Nope it is a string: varchar(255)

[The Little Guy]

You are limiting the query to return only 1 result. This is why you are getting only one result. Remove LIMIT 1 from the query.

B.T.W. I do only want one result no more than that

[cooldude832]

if your functions are unique say you want to do function eat an apple then don't pass its title but pass its functionID number in mysql across then you are always sure you get the right result.

A varchar compare has 100 more ways to fail than an integer to integer compare

[craygo]

Is there more code than that cause you won't get much from just that just the resource id which doesn't mead much.

 

This will list field name and value

<?php
$sql = "SELECT * FROM `roster` WHERE sort = 1";
$res = mysql_query($sql) or die(mysql_error());
$r = mysql_fetch_assoc($res);
foreach($r as $key => $val){
echo "$key = $val<br />";
}
?>

 

Ray

[The Little Guy]

Well... The line above just includes the database connection information.

 

I don't want to pass an ID number, because the manual I am making has the same "Format" as PHP.net, where you just type in: http://sitename.com/random or http://sitename.com/abs and it will take you to that function.

 

I have never had this issue before...