Php & Mysql Database Help

[tcooper]

I am not that familiar with how SQL works. I am trying to set up a form where the user will pick items that they want to have included in a SQL statement (Such as Job No, Client, etc). Then I will have another box where they can select the parameters of which to search by (such as date, etc). So far my statement looks like this:

mysql_select_db($database_Thor, $Thor);
$query_RstServices = "SELECT '$include' FROM POJOBDETAIL, POProjIdent WHERE PIDate = '2003-12-31' and POJJobNo=PIJobNo";
$RstServices = mysql_query($query_RstServices, $Thor) or die(mysql_error());
$row_RstServices = mysql_fetch_array($RstServices);
$totalRows_RstServices = mysql_num_rows($RstServices);

I am not exactly sure what all I am doing here...this is really some code that I found and have edited it to meet my needs.

My problem is that I don't know how to get the information out of the database and into a HTML table for the user to view. Any help would be GREATLY appreicated.

[dalecosp]

$foo="somejob";
$bar="somedate";

$query="select * from sometable where job='$foo' and date='$bar'";

$result=mysql_query($query);

if (!$result) {
     echo "There was an error.  SQL said ".mysql_error();
}

else {
     while ($row=mysql_fetch_array($result)) {
     echo "<li>$row</li>";  // or whatever HTML, tables, <br>'s etc.
}

[tcooper]

How can I add a variable name to Select rather than using *. I have a select box that allows multiple selections

  <td><strong>Information to include in the report: 
    <select name="selectQuyInfo[]" size="2" multiple onBlur="document.form1.submit()">
      <option value="PIJobNo">Job Number</option>		
      <option value="PIPrepBy">Prepared By</option>
      <option value="PIDate">Date Prepared</option>
      <option value="PIClient">Client</option>
      <option value="POJSkills">Skills</option>
      <option value="POJProjTeam">ProjTeam</option>
      <option value="PSStartDate">StartDate</option>
    </select>
    </strong></td>

Now based on what the user has chosen I put the answer into a variable (such as $search)

How can I do something like Select '$search' from SomeDatabse?

I can't seem to get this piece to work either. If I do a Select * I can get info on the screen but that is not what I want to do.

Thanks for your help.

[dalecosp]

Try using [man]switch/man:

switch($selectQuyInfo) {
   case "PIJobNo": 
      $search="name_of_job_number_table";
      break;
   case "PIPrepBy":
      $search="name_of_prep_table";
      break;
 // etc.

}

Keep in mind, these are just examples to get you going. I doubt they'll work without a tad of tweaking...