Selecting from DB

[talkster5]

Hi there
I am trying to select a button from a datbase and then show it using the data from the form

This is the code i have

<?php
$dbh=mysql_connect ("localhost", "hosting_admin", "****") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("hosting_prices");
$query="SELECT button FROM display WHERE type='$type' and slots='$slots'";
$res=mysql_query($query);
$button=mysql_result($res,0);
echo "$button"
?>

but i get this error
Warning: Wrong parameter count for mysql_result() in /home/hosting/public_html/prices/purchase.php on line 39

[cgraz]

Try checking to see if your query was actually executed without errors.

$res=mysql_query($query) or die(mysql_error()); 

Cgraz

[parawizard]

try this

<?php 
$dbh=mysql_connect ("localhost", "hosting_admin", "****") or die ('I cannot connect to the database because: ' . mysql_error()); 
mysql_select_db ("hosting_prices"); 
$query="SELECT button FROM display WHERE type='$type' and slots='$slots'"; 
$result=mysql_query($query); 
$dbinfo = mysql_fetch_row($result);
$button = $dbinfo[1];

echo $button;

?>

[talkster5]

ok the second post stopped the mySQL error but its not echoing the text i have stored in the database,

[talkster5]

ok i now have this

<?php
$dbh=mysql_connect ("localhost", "hosting_admin", "****") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("hosting_prices");
$query="SELECT button FROM display WHERE type='$type' and slots='$slots'";
$result=mysql_query($query); 
$dbinfo = mysql_fetch_row($result);
$button = $dbinfo[1];

echo "$button"; 
?>	

But when i run the query it doesnt show up the text from the database which is Hello World. So do i have something wrong with my code or is there something else wrong?

[batman]

Try changing the mysql_fetch_row to mysql_fetch_array:

<?php 
$dbh=mysql_connect ("localhost", "hosting_admin", "nomads") or die ('I cannot connect to the database because: ' . mysql_error()); 
mysql_select_db ("hosting_prices"); 
$query=mysql_query("SELECT button FROM display WHERE type='$type' and slots='$slots'"); 
$result=mysql_fetch_array($query);  

$button = $result['name of field here']; 

echo "$button";  

?>

Make sure that you change "name of field here" to the actual name of the field how its stored in the database.

[talkster5]

ok thx ill try it now

[talkster5]

nope it still wont output the text back to me.

[batman]

Well....in your query you are telling it to look WHERE type='$type' AND slots='$slots'

Unless these two variables ate set so the query will know where to look it wont give you anything.

For example:

<?php

$type = $_POST['type'];
$slots = $_POST['slots'];


$dbh=mysql_connect ("localhost", "hosting_admin", "nomads") or die ('I cannot connect to the database because: ' . mysql_error());  

mysql_select_db ("hosting_prices");  

$query=mysql_query("SELECT button FROM display WHERE type='$type' and slots='$slots'");
$rows = mysql_fetch_row($query);  

$result=mysql_fetch_array($query);   

if($rows < 1)
{
echo "Im sorry nothing was found.";
}
else
{
$button = $result['name of field here'];  

echo "$button";
}
?>

[talkster5]

well this time it echoed nothing was found ill take a look at the database and make sure i have everything correct

[batman]

As mentioned earlier you need to make sure that the two vars $type and $slots are set to something before you do the query. Are you giving those two variables values? If this is not then of course it wont find anything WHERE type='$type' AND slots='$slots'.

If these two variables are not set then this is what your query looks like.

$query=mysql_query("SELECT button FROM display WHERE type='' and slots=''");

The above query will not return anything, i dont know how to make this any more clear.

Let me know if this helps,

[talkster5]

it is supposed to get them from the form before which is below

<form name="form1" method="post" action="purchase.php">
          <div align="center">
            <table width="135" border="0">
              <tr>
                <td width="39">Type:</td>
                <td width="351"><select name="type" id="type" onchange="changeprice(price_for_type[document.form1.type.options.selectedIndex]-0, price_for_players[document.form1.slots.options.selectedIndex]-0);">
                  <option selected>Public</option>
                  <option>Private</option>
                </select></td>
              </tr>
              <tr>
                <td>Slots:</td>
                <td><select name="slots" id="slots" onchange="changeprice(price_for_type[document.form1.type.options.selectedIndex]-0, price_for_players[document.form1.slots.options.selectedIndex]-0);">
                  <option selected>08 Man</option>
                  <option>12 Man</option>
                  <option>16 Man</option>
                  <option>20 Man</option>
                  <option>24 Man</option>
                  <option>28 Man</option>
                  <option>32 Man</option>
                                </select></td>
              </tr>
              <tr>
                <td>Price:</td>
                <td>$
                <input name="textfield" type="text" size="6"></td>
              </tr>
              <tr>
                <td>&nbsp;</td>
                <td><input type="submit" name="Submit" value="Buy"></td>
              </tr>
            </table>

[batman]

Well....if your positive that those two variables are set, then it has to be a database error. Make sure that what you want is where its being called from by the query.

If thats confusing you let me know,

[talkster5]

everything seems correct in the database and matches what is being entered into the form

[batman]

Do you have AOL instant messanger or something similar? If so let me know and maybe we can talk later on tonight.