mysql search query

[hyster]

i found a script online that i edited to nearly what i need. it searchs the database and returns the found results. the problem i had was that it only display the results as 1 $var were as i wanted the $vars separate.

i managed to work out how to do that but now they dont loop and only displays the last row of info sent.

ive attached the php file as a txt file.

the only parts ive edited are added lines 63 - 68 change 121 - 129 from

<td><?php echo (count($results) > 0)?"Your search term: {$searchTerms} returned:<br /><br />" . implode("", $results):""; ?></td>
</tr>

to

<table width="800" border="1" align="center">
<tr>

<td width="160">Recon Sku</td>
<td width="110">Origanal SKU</td>
<td width="74">Make</td>
<td width="111">Model</td>
<td width="46" bgcolor="#00CC00">Status</td>
<td width="259">Actions</td>
</tr><tr>
<td><?php echo $test1 ; ?></td> <td><?php echo $test2 ; ?></td> <td><?php echo $test3 ; ?></td> <td><?php echo $test4 ; ?></td> <td bgcolor="#00CC00"><?php echo $test5 ; ?></td> <td><?php echo $test6 ; ?></td>

id like to keep the following part if possable

echo (count($results) > 0)?"Your search term: {$searchTerms} returned:

thanks for any help.

[ixalmida]

mysql_query() only returns a resource. Thus you need to use mysql_fetch_array() or mysql_fetch_assoc() to return an actual record. But in order to pull the NEXT record, you have to "fetch" the next row. In other words, in order to return multiple records, you have to move the record pointer.

For example, let's say you have the following Users table in your database:

 name | last_login | total_logins
----------------------------------------
Frank  | 2010-04-07 | 39
Bob    | 2010-03-29 | 17
Jan    | 2010-05-04 | 63

In order to display ALL of the records in the above recordset, this one way to do it:

// Get resource handle (recordset)...
$result = mysql_query("SELECT * FROM Users");

// Get each row of data...
while($row = mysql_fetch_assoc($result))
  {
  $data_str = implode(", ", $row);
  echo $data_str."<br />";
  }

This will produce the following output:
Frank, 2010-04-07, 39
Bob, 2010-03-29, 17
Jan, 2010-05-04, 63

[hyster]

thanks for the reply.

the origanal script works fine the same as u have laid out but what i want to do is have each $var in its own cell in a table and not all printed in 1 line.

the data that will be printed has variying lengths so will look a mess and be hard to read unless i can lay it out neatly.

[ixalmida]

Then you need to drop the implode() statement since you don't want the data in a string. Use extract() instead to create individual variables from the results.

Here's how to modify my example:

// Get resource handle (recordset)... 
$result = mysql_query("SELECT * FROM Users"); 

// Start of tabular output...
echo "<table>\n";
echo "<tr><td>User Name</td><td>Last Login</td><td>Total Logins</td></tr>\n";

// Get each row of data... 
while($row = mysql_fetch_assoc($result)) 
  { 
  extract($row); 
  echo "<tr><td>".$name."</td><td>".$last_login."</td><td>".$total_logins."</td></tr>\n"; 
  }
echo "</table>\n";

Note: '\n' = newline, which formats the HTML source only.

[ixalmida]

Have you added up the pixel width of your columns? Your columns add up to 760 pixels, but your table width is 800 pixels (or actually 798, since you have a 1px border).

You might just ditch the pixels and go with percentages. Since the overall table size is static, a percentage width for your columns should give you the same number of pixels every time - and you only have to add up to 100&#37;.

🙂

[hyster]

big thanks for ur help but i can not work out how to incorparate it into my script.

im not worried about the cosmetics as i prefer to get the script working then take time with the looks. ive spent to much time messing with the looks to get it to look ok, only to add some thing then it messes it up again.