PHP Help

[Chris_Evans]

Hi there,
I have a template that looks as follows:

<tr>
     <td>
     [NAME1]
     </td>
     <td>
     [NAME2]
     </td>
     <td>
     [NAME3]
     </td>
</tr>

Those NAME1, NAME2, NAME3 etc are supposed to be replaced by the results from the DB. The code I currently have works for one TD, but I'm at a loss as to how to make it work for three.

		// Format the results to specified
		// standards
		while($search_array = mysql_fetch_array($this->results)) {
			// Create temp_start to store each html entity in
			$this->temp_html = $this->formatted_results;

		// Create a name without spaces
		$search_array['nameurl'] = urlencode($search_array['name']);

		// Go through the search array,
		// replacing each item.
		foreach($search_array as $key => $value) {
			$this->temp_html .= str_replace("[".strtoupper($key)."]", $value, $this->temp_html);
		}

		$html .= $this->temp_html;
	}

	$this->formatted_results = $html;

Now I thought about using $i++ etc to work out the numbers, then after each three, reset $i back to 0 to start a new row. I think this would work, but then, if the database doesn't contain a third row, one of those fields will be left showing [NAME3] rather than just being left blank...

Any help would be appreciated. 🙂

Thanks,

Chris

[biggus]

name1, name2, name3 are all fields in your database?

Looking at what you posted, $search_array['name'] would replace the NAME part of each of the [NAMEx] strings, unless $search_array['name1'], $search_array['name2'], and $search_array['name3'] came first in the array. If the 3 are fields in the db, then I'd say just call them by name, rather than using a loop.

$this->temp_html = str_replace("[NAME1]", $search_array['name1'] , $this->temp_html);

This would also remove the [NAMEx] if there's no data for it in the db.

[Chris_Evans]

Hi there,
Thanks for the reply... thought this had disappeared enough that people wouldn't see it by now. 😃

		// Format the results to specified
		// standards
		while($search_array = mysql_fetch_array($this->results)) {
			$i++;

		// Create temp_start to store each html entity in
		if($i == "1") {
			$this->temp_html = $this->formatted_results;
		}

		// Create a name without spaces
		$search_array['nameurl'] = urlencode($search_array['name']);

		// Go through the search array,
		// replacing each item.
		foreach($search_array as $key => $value) {
			echo $i."<br>";
			$this->temp_html .= str_replace("[".strtoupper($key).$i."]", $value, $this->temp_html);
		}

		if($i == "3") {
			$html .= $this->temp_html;
			echo $this->temp_html;
		}
	}

	$this->formatted_results = $html;

I've changed it some what, but it works now. 🙂 Thanks.