mysql query problems

goosez22

I am trying to make buttons holding data that will query a mysql database. They are holding the letters that correspond with what they will display.

html:

php:

<?php
$connection = mysql_connect("localhost", "user", "pass");
mysql_select_db("database", $connection);

$result = mysql_query("SELECT username
FROM users
WHERE username
between $_POST['name']");

echo "<table border='1'>";
echo "<tr><th>Username</th>;
while($row = mysql_fetch_row($result)) {
echo "<tr><td>";
echo $row['name'];
echo "</td><tr>";
}
echo "</table>";

mysql_close($connection);
?>

I haven't found any information out there about buttons. I have only found stuff on text fields and submit buttons. I want to be able to just click the button and it take me to the results.

Any ideas on how else to do this because this doesn't seem to work?

devinemke

i assume you are trying to select usernames that start with the letters specified in the button ranges. if so:

<?
if (!isset($_POST['submit']))
{
	echo '
	<form action="" method="post">
	<input type="submit" name="submit" value="A thorugh C">
	<input type="submit" name="submit" value="D thorugh H">
	<input type="submit" name="submit" value="I thorugh K">
	<input type="submit" name="submit" value="L thorugh P">
	<input type="submit" name="submit" value="T thorugh Z">
	</form>
	';
}
else
{
	$connection = mysql_connect('localhost', 'user', 'pass');
	mysql_select_db('database', $connection); 

$explode = explode(' thorugh ', $_POST['submit']);
$result = mysql_query('SELECT username FROM users WHERE username REGEXP "^[' . $explode[0] . '-' . $explode[1] . ']" ORDER BY username');
while ($row = mysql_fetch_assoc($result))
{
	echo $row['username'] . '<br>';
}
}
?>

goosez22

This works exactly the way i want it to.

thanks for the help