PHP - Second Argument Error

I'm getting an invalid argument error for my While loop.  I can't figure out why. 

Code: [Select]
$sql="SELECT * FROM schools ORDER BY class DESC,sectional ASC,team ASC";

$results = mysql_query($sql);

while ($team = mysql_fetch_assoc($results)) {

echo $team['school'] . '<br>';

}


Here is the error:

Quote

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/******/public_html/hoosierhoopsmagazine.com/resources/sectional_assignments.php on line 7

I have a table with a list of users and an edit button and delete button.  When the edit button is pressed on a site it passes the user_id as p_id to the page that catches it and displays the data.  The problem is when I click on the "update user" button, I get the following error:

Warning: Undefined variable $the_user_id in C:\xampp\htdocs\3-19-21(2) - SafetySite\admin\edit_user.php on line 10

Fatal error: Uncaught TypeError: mysqli_fetch_assoc(): Argument #1 ($result) must be of type mysqli_result, bool given in C:\xampp\htdocs\3-19-21(2) - SafetySite\admin\edit_user.php:14 Stack trace: #0 C:\xampp\htdocs\3-19-21(2) - SafetySite\admin\edit_user.php(14): mysqli_fetch_assoc(false) #1 {main} thrown in C:\xampp\htdocs\3-19-21(2) - SafetySite\admin\edit_user.php on line 14

The weird thing is I had another update user page with a table I created that ran the query to update the table in the database just fine.  But as I created it, it didn't look all that great so I recreated the page and used a bootstrap table because of the much cleaner look.  Both pages have the exact same PHP code, the only difference is the bootstrap table I added in.  So I'm really at a loss with this.  Other than the table and PHP code, there is a script at the bottom of the page for the table itself to allow for searching within the table, i'll include that as well.  The PHP code is as follows:

<?php

//THE "p_id" IS BROUGHT OVER FROM THE EDIT BUTTON ON VIEW_ALL_USERS

if (isset($_GET['p_id'])) {

    $the_user_id = $_GET['p_id'];

}

// QUERY TO PULL THE SITE INFORMATION FROM THE p_id THAT WAS PULLED OVER

$query = "SELECT * FROM users WHERE user_id = $the_user_id ";

$select_user = mysqli_query($connection,$query);

//SET VALUES FROM ARRAY TO VARIABLES

while($row = mysqli_fetch_assoc($select_user)) {

    $user_id = $row['user_id'];

    $user_firstname = $row['user_firstname'];

    $user_lastname = $row['user_lastname'];

    $username = $row['username'];

    $user_email = $row['user_email'];

    $user_phone = $row['user_phone'];

    //$user_image = $row['user_image'];

    $user_title_id = $row['user_title_id'];

    $user_role_id = $row['user_role_id'];

   }

THE UPDATE QUERY CODE....................................................................................................................

<?php

if(isset($_POST['update_user'])) {

    $user_id = $_POST['user_id'];

    $user_firstname = $_POST['user_firstname'];

    $user_lastname = $_POST['user_lastname'];

    $username = $_POST['username'];

    $user_email = $_POST['user_email'];

    $user_phone = $_POST['user_phone'];

    //$user_image = $_POST['user_image'];

    $user_title_id = $_POST['user_title_id'];

    $user_role_id = $_POST['user_role_id'];

    

    $query = "UPDATE users SET ";

    $query .= "user_id = '{$user_id}', ";

    $query .= "user_firstname = '{$user_firstname}', ";

    $query .= "user_lastname = '{$user_lastname}', ";

    $query .= "username = '{$username}', ";

    $query .= "user_email = '{$user_email}', ";

    $query .= "user_phone = '{$user_phone}', ";

    //$query .= "user_image = '{$user_image}', ";

    $query .= "user_title_id = '{$user_title_id}', ";

    $query .= "user_role_id = '{$user_role_id}' ";

    $query .= "WHERE user_id = '{$the_user_id}' ";

    $update_user = mysqli_query($connection,$query);

    if(! $update_user) {

        die("QUERY FAILED" . mysqli_error($connection));

    }

}

?>

THE "UPDATE USER" BUTTON THE USER CLICKS ON TO UPDATE....................................................................................................................

<div class="col-1">

<button class="btn btn-primary" type="submit" name="update_user">Update User</button>

</div>

 

Any Help is Greatly Appreciated!

Edited March 23 by Zserene

Hi all,

I don't know php, but i have a script i would like to be able to also run from shell, like: "php script arg1"...
if (isset($_SERVER['argc'])) {
    $postip = $1;
} else {
    $postip = $_POST["ip"];
}

How do i assign $postip = $1; (or is it infact $2...) ?
My script gives me this error now: PHP Parse error:  syntax error, unexpected T_LNUMBER, expecting T_VARIABLE or '$'

Thanks in advance :-) !

Hi,

I am attempting to export some table data to an excel spreadsheet. I am having trouble with the final few lines and getting the following error within the spreadsheet (which is otherwise working well).

Quote

The argument should be an array in/home/website/public_html/student_list_export.php on line 34

I get the same error message for the line below also (echo implode("\t", array_values($row)) . "\n".

I'm at a loss. This seems like a pretty obvious and direct error message but I can't get it working properly. Can somebody please help me?

Below is the code I am working with.
<?php 

include('includes/admin_session.php');

require_once("includes/connection.php"); 

function cleanData(&$str) {

  $str = preg_replace("/\t/", "\\t", $str);
  $str = preg_replace("/\r?\n/", "\\n", $str);

  if(strstr($str, '"')) $str = '"' . str_replace('"', '""', $str) . '"';

}
// file name for download
$filename = "student_list_" . date('Ymd') . ".xls";

header("Content-Disposition: attachment; filename=\"$filename\"");
header("Content-Type: application/vnd.ms-excel");

$flag = false;

$result = mysqli_query($connection,"SELECT * FROM students ORDER BY tutor") or die(mysqli_error($connection));

while(false !== ($row = mysqli_fetch_assoc($result))) {
  if(!$flag) { // display field/column names as first row
    echo implode("\t", array_keys($row)) . "\n";
    $flag = true;
  }
  array_walk($row, 'cleanData');
  echo implode("\t", array_values($row)) . "\n";
  
  }
  
  ?>

I'm trying to list all the tables in my database.  I got this code pretty much "word" for word from the example at php.net, but I get:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\wamp\www\test\test-in.php on line 67

<?php $db= $_POST['db'];
$sql= "SHOW TABLES FROM $db";
$result=mysql_query($sql);
while ($tblarray = mysql_fetch_row($result)){
?><a href="?tablename=<?php echo $tblarray[0];?>"><?php echo $tblarray[0];?></a><?php
}
?>

Hey all. I have a function called displayForm in a form validation script. This function accepts a few arguments but these arguments are empty upon initial calling of the function. One of the arguments is and errors array that only gets populated if there were form errors.

So upon running my script initially I get missing argument Warnings.

Can these warnings simply be ignored? Would they cause problems throughout my script if I ignore these warnings? And how can I suppress these warnings if I would like to?

Thanks all for your help.

Cheers.

How do I make my constructor work when I don't pass in an argument.  That is, it should efault to null.

Code: [Select]
class Something{
private $type=null;

public function __construct($t){
$this->type = $t;
}

public function setSomething($t){
$this->type = $t;
}

public function getSomething(){
if (is_null($this->type)) {
return "None for you!";
} else {
return "Something is " . $this->type . ".";
}
}
}


TomTees

Hello, i know this is a very silly question but it bothers me to know the reasoning behind it. My application has a design where the functions are stored in functions.php and variables are stored in variables.php. There are some functions that have variables that i might change often and the reason i don't directly use them in the argument itself is so that in future if i have to change the default argument's value , then i wouldn't have to scroll through all the functions and look for it. I have a slippery memory i know i will be able to remember it better if i store custom global variables separately and custom global functions separately.

I tried searching these forums for this but its giving me a message like "search daemon not found" or something like that..

Anyways , coming to the point, i know that PHP doesn't accept variables as default arguments but may i know the reasoning behind this? If i understand the reasoning behind this i know it will stick better in my head.So..why does a function not allow a variable as a default value?

Or if anyone has a link to explaining this behaviour in PHP, i would appreciate it if you could pass it on!

Thank you

I've been challenging myself to get the system() argument working for the past hour and something. I still can't get it working so I ask for assistance.

system ("cp /var/www/http/test.com/products/".$fordir['fordir']."/".$category['category']."/".$_POST['id']." /home/n/Documents/My\ Sites/test.com\ codebase");

The error log doesn't say anything, so I suspect that PHP is not even attempting to parse the code.

Can anyone spot something that shouldn't be the way it is?

Hey guy's, have been stuck at this hurdle for a little whole now and I can't seem to find the right solution and would very much appreciate anyones help on this.

Ok, so I have a table of votes and each time a user votes, they're added to this table. Now, I have a 'pool' table which will display certain items. What I'm trying to do is display the 'pool' items, but if this specific user has already voted on this particular item, then I want it to skip the item in the 'pool' and go to the next item, until the argument of has that user voted is false.


The current code I'm pasting will obviously not work, it isn't even in the right position, but I've separated it so that you can hopefully understand what I'm trying to do in order to help.



Below is the code I use to check if a user has already voted on a particular photo:

<?php
$result=mysql_query("SELECT * FROM votes WHERE vVoter='$_SESSION[userID]' AND vPhoto='$_SESSION[currentphoto]'");
$rowCheck = mysql_num_rows($result);
$alreadyv = 0;
if($rowCheck > 0){
   $alreadyv = 1;
        //user has already voted on this photo, need to use this info to be able to skip it in the 'pool'
} else {
   //do nothing
}
?>

totalVoted is basically how many times a user has voted, so that people who vote more, get more votes:

<?php
$result=mysql_query("SELECT * FROM pool ORDER BY totalVoted DESC LIMIT 1");
$rowCheck = mysql_num_rows($result);

if($rowCheck > 0){
   while($row = mysql_fetch_array($result)){
      $photoid = $row['photoInPool'];
      
         $result2=mysql_query("SELECT * FROM photos WHERE pID='$photoid'");
         $rowCheck2 = mysql_num_rows($result2);

         if($rowCheck2 > 0){
            while($row2 = mysql_fetch_array($result2)){
               if($alreadyv == 1) {
                  //I NEED THIS TO SHOW THE NEXT PHOTO IN THE ARRAY, HOWEVER, IF THEY HAVE ALREADY VOTED ON THE NEXT PHOTO, IT WILL STILL DISPLAY IT, THIS IS MY PROBLEM I NEED HELP WITH PLEASE
               } elseif ($alreadyv != 1) {
                  $fname = $row2['pFileName'];
               }
            }
         }
   
      $_SESSION[currentphoto] = $row['photoInPool'];
      echo "<center><img src='user_images/$fname'></center>";
   }
}

?>

I hope I've explained this well enough and hope somebody can help. Many thanks in advance

I have been scripting (some may say programming) in PHP for last 5 years but never faced this issue. Interesting!

Say for example, I created a custom function with one argument:

function myFunc($arg1) {
echo $arg1;
}

Now, if I call this function without supplying any argument it doesn't give any error/warning. Any other high level language like C++ or Java would produce error in this case. So, I had to modify my code as follows:


function myFunc($arg1) {
if (!isset($arg1)) {
echo "Missing argument 1";
}
echo $s;
}

But this is annoying. Now I have to add these EXTRA lines of code in every function and class methods I have created. Is there any shortcut/easy method that the script will always produce an error if its missing any required argument? I have tried with adding error_reporting(E_ALL); at the very beginning of my code. But it still didn't work out. By the way, I am using PHP 5.3.1 on Apache/2.2.14 (Unix).

Any suggestion will be appreciated.

Hi,
I am a beginner with php and I am having a hard time understanding a section in my code.
The part I dont get is why we have to minus 1 from the number being passed into the array.

For example, $FaceNamePlural[$die1-1]

I tried looking at it over and over but I'm still very confused.
Can anyone help me on this...Thanks.

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Untitled Document</title>
</head>

<body>
<?php

$FaceNameSingular = array("one", "two", "three", "four", "five", "six");
$FaceNamePlural = array("ones", "twos", "threes", "fours", "fives", "sixs");
 
function CheckForDoubles($die1, $die2)
{
    global $FaceNameSingular;
    global $FaceNamePlural;
    
    if($die1 == $die2) //  doubles
        echo "The roll was double ", 
            $FaceNamePlural[$die1-1], "<br />";
    if($die1 != $die2) //not doubles
        echo "The roll was a ", $FaceNameSingular[$die1-1], 
            " and a ", $FaceNameSingular[$die2-1], ".<br />";
            
}

function DisplayScoreText($Score)
{
    if($Score == 2)
        echo "you roll snake eyes! <br />";
        
    if($Score == 3)
        echo "you roll loose duece! <br />";
            
    if($Score == 5)
        echo "you roll fever five! <br />";
    
    if($Score == 7)
        echo "you roll natural! <br />";
        
    if($Score == 9)
        echo "you roll nina! <br />";
    
    if($Score == 11)
        echo "you roll yo! <br />";
        
    if($Score == 12)
        echo "you roll boxcars! <br />";                
}

$dice = array();
$dice[0] = rand(1,6);
$dice[1] = rand(1,6);
$Score = $dice[0] + $dice[1] ;
echo "<p>";
echo "The total score for the roll was $Score . <br />";

CheckForDoubles($dice[0],$dice[1]);
DisplayScoreText($Score);
echo "</p>";
?>
</body>
</html>

Firstly i am new to php.Iv currently got this while loop iterating through a database drawing polygons from the info in the datatable.each polygon has its own id stored in the datatable and with the on click event i am trying to just output to the screen the specific id of the polygon clicked on.It looks ok to me but it doesnt work for some reason. Below is the loop and the function it is trying to call.
///////////////////////////////////////////////////////////////////////
<?php
             while($info = mysql_fetch_array( $data )){
                 echo "<polygon fill=".$info['fill_colour']." stroke=\"black\" id=".$info['id']." onclick=\"buildingClick(id)\" points=".$info['coordinates']." />";
            
            
         }
?>
///////////THIS IS THE FUNCTION///////////////////////////
 <?php
    function buildingClick($id) {
    
    echo "building id : {$id}";
            
     }
 ?>
///////////////////////////////////////////////////////////////////

If anyone could help it would be hugely appreciated.
Eoin

I am having problem with my edit.php page,

Keep on getting Invalid argument supplied for foreach()

My edit.php is suppose to get the drop down list from the first page. and replace the string [Replace] with whats in the list box But it has to Use the first thing in the list box 2 times, and ect.


Code: [Select]
<form method="post" action="edit.php" >

<select name="drop1">
<?php echo $dropdownOptions; ?>
</select>
<input type="submit" value="drop1" />
</form>

Edit.php

Code: [Select]
<?

$file = file_get_contents('myfile.txt');

foreach($_POST['drop1'] as $replace) {

   

$file = preg_replace('#\[Replace\]#', $replace, $file, 2);
}

?>

Hi everyone!!

I finish to do my second populating drop down list. it's not realy the display I was looking but for now it will be good. but when I click on my serach button I receive this erro.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\scale24-25\search-keyword.php on line 112

this is what line 112 is in the search file.

 //-create  while loop and loop through result set   
   while($row=mysql_fetch_array($result)){   <--------------  line 112
         

here's the code of my form...

<?php
include_once("connection.php");
//////////////////////////////
?>
<!doctype html public "-//w3c//dtd html 3.2//en">

<html>

<head>
<title>1/24 - 1/25 scale model database</title>
<SCRIPT language=JavaScript>
function reload(form)
{
var val=form.cat.options[form.cat.options.selectedIndex].value;
self.location='search-db-foreach.php?cat=' + val ;
}

</script>
</head>

<body >
<img src="http://www.scale24-25.com/images/banners/banner.jpg" alt="banner" width="997" height="213" border="0" usemap="#Map" />
<map name="Map" id="Map">
<area shape="poly" coords="0,100,85,102,92,55,108,50,326,51,323,7,3,3" href="http://www.hobby-shop.qc.ca" alt="hobby-shop" />
<area shape="poly" coords="672,57,891,53,887,4,995,4,985,108,673,102" href="http://www.hobby-shop.qc.ca" alt="hobby-shop" />
<area shape="poly" coords="326,13,330,53,98,54,90,92,670,99,668,54,889,51,886,5" href="http://www.scale-auto-style.com" alt="" />
</map>
<?php

if (isset($_POST['todo']) && $_POST['todo'] == "search") {    $todo=$_POST['todo'];

$manufacturer_reel=$_POST['manufacturer_reel'];

$query="select * from kit where  ";

////////// Including manufacturer_reel field search ////
if(strlen($manufacturer_reel) > 0 ){
$query.= " manufacturer_reel='$manufacturer_reel' and "; 
}  
//// End of class field search ///////////

$query=substr($query,0,(strLen($query)-4));

echo $query;
echo "<br><br>";
$nt=mysql_query($query);
echo mysql_error();

// End if form submitted



}else{

echo "<form method=post action='search-keyword.php?go'><input type=hidden name=todo value=search>";
?>
<table width="960" border="0">
  <tr>
    <td colspan="3"><table width="100%" border="0">
      <tr>
        
  </tr>
  <tr>
    <td><div align="right"></div></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div align="right">Echelle du modele</div></td>
    <td align="center">
<?php 
//  strat of drop down  ///
$q=mysql_query("SELECT DISTINCT scale FROM kit ORDER BY scale");
echo '<select name="scale"><option value="scale">Please Choose an Option</option>';
while($row = mysql_fetch_array($q)) {
$thing = $row['scale'];
echo '<option>'.$thing.'</option>';
}
echo "</select>";

echo " <br> \n";
echo " <br> \n";

?></td>
    <td><div align="left">Scale of model</div></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td><div align="right"></div></td>
  </tr>
  <tr>
    <td><div align="right">Nom du manufacturier automobile</div></td>
    <td align="center"><?php
//  strat of drop down  ///
/*
If register_global is off in your server then after reloading of the page to get the value of cat from query string we have to take special care.

 

@$cat=$_GET['cat']; // Use this line or below line if register_global is off
if(strlen($cat) > 0 and !is_numeric($cat)){ // to check if $cat is numeric data or not. 
echo "Data Error";
exit;
}

*/
@$cat=$HTTP_GET_VARS['cat']; // Use this line or above line if register_global is off

///////// Getting the data from Mysql table for first list box//////////
$quer2=mysql_query("SELECT DISTINCT manufacturer_reel,manufacturer_reel_id FROM kit order by manufacturer_reel"); 
///////////// End of query for first list box////////////

/////// for second drop down list we will check if manufacturer_reel is selected else we will display all the car_model///// 
if(isset($cat) and strlen($cat) > 0){
$quer=mysql_query("SELECT DISTINCT car_model FROM kit where manufacturer_reel_id=$cat order by car_model"); 
}else{$quer=mysql_query("SELECT DISTINCT car_model FROM kit order by car_model"); } 
////////// end of query for second car_model drop down list box ///////////////////////////


//////////        Starting of first drop downlist /////////
echo "<select name='cat' onchange=\"reload(this.form)\"><option value=''>Select one</option>";
while($noticia2 = mysql_fetch_array($quer2)) { 
if($noticia2['manufacturer_reel_id']==@$cat){echo "<option selected value='$noticia2[manufacturer_reel_id]'>$noticia2[manufacturer_reel]</option>"."<BR>";}
else{echo  "<option value='$noticia2[manufacturer_reel_id]'>$noticia2[manufacturer_reel]</option>";}
}
echo "</select>";
//////////////////  This will end the first drop down list ///////////

//////////        Starting of second drop downlist /////////
echo "<select name='subcat'><option value=''>Select one</option>";
while($noticia = mysql_fetch_array($quer)) { 
echo  "<option value='$noticia[car_model]'>$noticia[car_model]</option>";
}
echo "</select>";
//  end of drop down  ///
echo " <br> \n";
echo " <br> \n";
//  end of drop down  ///

?></td>
    <td><div align="left">Name Of vehicule manufacturer</div></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td><div align="right"></div></td>
  </tr>
  <tr>
    <td><div align="right">Nom du manufacturier de modele reduit</div></td>
    <td align="center"><?php
//  start of drop down  ///
$q=mysql_query("SELECT DISTINCT manufacturer_kit FROM kit ORDER BY manufacturer_kit");
echo '<select name="manufacturer_kit"><option value="kit manufacturer">Please Choose an Option</option>';
while($row = mysql_fetch_array($q)) {
$thing = $row['manufacturer_kit'];
echo '<option>'.$thing.'</option>';
}
echo "</select>";
 
//  end of drop down  ///
echo " <br> \n";
echo " <br> \n";

?></td>
    <td><div align="left">Name Of kit manufacturer</div></td>
  </tr>
  <tr>
    <td><div align="right"></div></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div align="right">Annee de fabrication du Vehicule</div></td>
    <td align="center"><?php
//  strat of drop down  ///
$q=mysql_query("SELECT DISTINCT year_prod_reel FROM kit ORDER BY year_prod_reel");
echo '<select name="year_prod_reel"><option value="vehicules year manufactured">Please Choose an Option</option>';
while($row = mysql_fetch_array($q)) {
$thing = $row['year_prod_reel'];
echo '<option>'.$thing.'</option>';
}
echo "</select>";
//  end of drop down  ///
echo " <br> \n";
echo " <br> \n";
 
 ?></td>
    <td><div align="left">Year of production of the vehicule</div></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td align="center">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td><div align="right"><strong></strong></div></td>
    <td align="center">
<?php
 
echo "
<br><input type=submit value=Search name='name' action='search-keyword.php?go' >
</form>
";
}


?>
<td><div align="left"><strong></strong></div></td>

      
    </table>    





</body>

</html>


    

and this the search file

<?php

include_once("connection.php");
//////////////////////////////
?>
<!doctype html public "-//w3c//dtd html 3.2//en">

<html>

<head>
<title>(Type a title for your page here)</title>

</head>

<body >
<p align="center"><img src="http://www.scale24-25.com/catalog/images/banners/banner.jpg" alt="banner" width="997" height="213" border="0" usemap="#Map" />
<map name="Map" id="Map">
<area shape="poly" coords="0,100,85,102,92,55,108,50,326,51,323,7,3,3" href="http://www.hobby-shop.qc.ca" alt="hobby-shop" />
<area shape="poly" coords="672,57,891,53,887,4,995,4,985,108,673,102" href="http://www.hobby-shop.qc.ca" alt="hobby-shop" />
<area shape="poly" coords="326,13,330,53,98,54,90,92,670,99,668,54,889,51,886,5" href="http://www.scale-auto-style.com" alt="" />
</map></p>
<table width="920" border="0">
  <tr>
    <td width="359"><p class="style5">You will find some TBC. TBC is for &quot;To Be Confirmed&quot;. If somebody know the missing information ( TBC ) it will be appreciate to send it to me at this mail: <a href="mailto:info@hobby-shop.qc.ca">info@hobby-shop.qc.ca</a> <br />
        <br />
thanks in advance for your help</p>
    </td>
    <td width="161"><div align="center"><a href="search-db-foreach.php"><img src="catalog/images/design_web/othersearch.jpg" border="0" alt="search" width="150" height="96"></a></div></td>
    <td width="386"> <div align="right">
      <p>This logo <img  src= 'http://www.scale24-25.com/images/PDF_logo.gif' width='50' height='50'/> mean that you can download a PDF file. To read it you need minimum Acrobat reader and you can download it <a href="http://get.adobe.com/reader/">here</a></p>
      <p>Some link will return a TBC. Sorry for any inconveniant. as soon as we will receive or do the PDF it will be updated.</p>
    </div></td>
  </tr>
</table>


<br>







<?php
if (isset($_POST['todo']) && $_POST['todo'] == "search") {    $todo=$_POST['todo'];

$name=$_POST['cat'];
$name1=$_POST['manufacturer_kit'];
$name2=$_POST['year_prod_reel'];
$name3=$_POST['scale'];
$name11=$_POST['subcat'];


//-query  the database table for the post field  

$sql="SELECT  kit_id, kit_number, kit_name, description_eng, description_fr, manufacturer_kit, manufacturer_reel, manufacturer_reel_id, scale, engine_detail, year_prod_kit, year_prod_reel, image_id, image_id1, image_id2  FROM kit ";
    $sqlOperand="WHERE";
    if ($name != "cat") {
        $sql = $sql . $sqlOperand . " cat LIKE '%" . $name ."%' ";
        $sqlOperand = " AND ";
    }
    if ($name1 != "kit manufacturer") {
        $sql = $sql . $sqlOperand . " manufacturer_kit LIKE '%" . $name1 ."%' ";
        $sqlOperand = " AND ";
    }
if ($name11 != "subcat") {
        $sql = $sql . $sqlOperand . " subcat LIKE '%" . $name11 ."%' ";
        $sqlOperand = " AND ";
    }
    if ($name2 != "vehicules year manufactured") {
        $sql = $sql . $sqlOperand . " year_prod_reel LIKE '%" . $name2 ."%' ";
        $sqlOperand = " AND ";
    }
    if ($name3 != "scale") {
        $sql = $sql . $sqlOperand . " scale LIKE '%" . $name3 ."%' ";
        $sqlOperand = " AND ";
    }
    if ($sqlOperand == "WHERE") {
           echo  "<p>Please enter a search query</p>";   
    } 

else {
   //   echo '<img src="web-design/sorry.jpg" alt="sorry">';
       
       // echo "Sorry nothing match your selection / Desolle rien ne correspond a votre selection";
   // echo "run sql: <BR> $sql <BR> and display results";
    }


 
  //-run  the query against the mysql query function   
   $result=mysql_query($sql);  
   
  //-make the header of the table   
   
   echo "  <table align=center width=\"1340\" border=\"\">\n";
   echo "    <tr>\n";
   echo"  <td nowrap align=center width='95'>  kit manufacturer  \n";
   echo"  <td nowrap align=center width='55'> scale \n";
   echo"  <td nowrap align=center width='90'> kit number \n";
   echo"  <td nowrap align=center width='290'> kit name \n";
   echo"  <td nowrap align=center width='400'> description \n";
   echo"  <td nowrap align=center width='125'> vehicule year \n";
   echo"  <td nowrap align=center width='80'> complete engine detail\n";
   echo"  <td nowrap align=center width='80'> Select Picture to get bigger\n";
   echo"  <td nowrap align=center width='75'> instruction sheet\n";
   echo"  <td nowrap align=center width='75'> box contain\n";
   echo "    <tr>\n";

   //-create  while loop and loop through result set   
   while($row=mysql_fetch_array($result)){   
         $description_eng  =$row['description_eng'];   
         $manufacturer_kit=$row['manufacturer_kit']; 
 $scale=$row['scale']; 
 $manufacturer_reel=$row['manufacturer_reel'];   
         $kit_id=$row['kit_id']; 
 $kit_number=$row['kit_number'];
 $kit_name=$row['kit_name'];
 $engine_detail=$row['engine_detail'];
 $year_prod_reel=$row['year_prod_reel'];
 $image_id=$row['image_id'];
 $image_id1=$row['image_id1'];
 $image_id2=$row['image_id2'];

 
   
   //-create  table of item during he while loop
   
echo "  <table align=center width=\"1340\" border=\"\">\n";    
echo"  <td nowrap align=center width='95'>  $manufacturer_kit  \n";
echo"  <td nowrap align=center width='55'>  $scale  \n";
echo"  <td nowrap align=center width='90'> $kit_number \n";
echo"  <td nowrap align=center width='290'> $kit_name \n";
echo"  <td nowrap width='400'> $description_eng \n";
echo"  <td nowrap align=center width='125'> $year_prod_reel \n";
echo"  <td nowrap align=center width='80'> $engine_detail \n";
echo"  <td nowrap width='80'> <a href=".$image_id.">   <img src='".$image_id."' width='75' height='50' border='0'/>";
echo"  <td nowrap width='75'> <a href= ".$image_id1.">   <img src= 'http://www.scale24-25.com/images/PDF_logo.gif' width='50' height='50' border='0'/>";
echo"  <td nowrap width='75'> <a href=".$image_id2.">   <img src='http://www.scale24-25.com/images/PDF_logo.gif' width='50' height='50' border='0'/>";
echo "    </tr>\n";
echo "    </table>\n"; 
echo "    </tr>\n";
echo "    </table>\n";
 

   }   
   }  
   else{   
   echo  "<p>Please enter a search query</p>";   
   }   
   
 ?>  


  



</body>

</html>


so what I do wrong. I knowI forgot something but what????

thanks in advance for your help

sebastien