[RESOLVED] Please HELP! Re: Form->PHP->Database

[xynah]

[FONT="Verdana"]
Hi, I'm only a PHP newbie and I am currently working on a way to get info that is stored on the database. The form goes like this:

<form method="post" action="query.php" name="frmBox">
  <table width="5%" border="0" cellspacing="1" cellpadding="1">
    <tr> 
      <td> 
        <input name="invNum" maxlength="6" tabindex="6"/>
      </td>
    </tr>
    <tr> 
      <td> 
        <input type="submit" name="submit" value="Go!" class="button" tabindex="6"/>
      </td>
    </tr>
  </table>
</form>

Now (please don't laugh at me!) this is how I did my query.php file... and it doesn't work at all. Could any Genius (if not everyone) out there help me out???
[/SIZE][/FONT]

<?php
// get values from input form
$id = $_REQUEST['invNum'];

$username = "username";
$password = "password";
$database = "database";

#CONNECT TO MYSQL
$dbcnx = @mysql_connect('localhost',$username,$password) or die("Unable to connect to MySQL");

#CONNECT TO DATABASE
@mysql_select_db($database) or die( "Unable to select database");

#CREATE THE QUERY
$sql = 'SELECT `DATE` , `LOCATION` FROM `Folder` WHERE  `ID` = "$id"'
        . ' ORDER BY `DATE` LIMIT 0, 30';

#EXECUTE QUERY
$rs = mysql_query($sql,$dbcnx) or die(mysql_error());

while($row = mysql_fetch_array($rs))   

{
echo "<br>",$row['DATE'],": ",$row['LOCATION']; 
}
?> 

[FONT="Verdana"]I also wanted the result of the query to be posted in a presentable manner, like maybe on a table (?). Is there a way to do that?[/FONT]

[sheephat]

http://www.w3schools.com/php/php_mysql_insert.asp

[xynah]

Hello sheephat,

I appreciate your quick reply. But the form that I am working on is made not to insert new data to the database. It is made to provide the criteria to select specific records from the database. The issue that I'm having is that the query isn't recognizing the object (invNum) I'm using in my html form to run the query. The form should allow others to input the invNum (in the form) which is equivalent to the (database) table's column ID.

What should I do to make this form work?

[sheephat]

Oh i see, i have a sample somewhere,

Something like this:

$sql = ("SELECT * FROM Folder WHERE id = '$id' ORDER BY date Limit 0, 30");

[xynah]

Great! Now, it finally works 🙂

Thanks!