I'm seeing double

Liquidice

I am working on a basic php/mysql search for my website. The code excutes properly, but returns double on every line in the query results.

Example:

1 1 Test part$0.00 Test part$0.00 test part test part

Anyone have any ideas what would cause this?

If you would like to see for yourself the website is

http://www.cyberspaceofframp.com/index.htm

[deleted]

It helps if you also post the relevant piece of code.

Liquidice

<?php

$link = mysql_connect("192.168.1.3", "root")
or die ("Could not connect to MySQL");

mysql_select_db ("offramp")
or die ("Could not select database");

$query = "SELECT * FROM test";
$result = mysql_query ($query)
or die ("Query failed");

// printing HTML result

print "<table>\n";
while ($line = mysql_fetch_array($result)) {
print "\t<tr>\n";
while(list($col_name, $col_value) = each($line)) {
print "\t\t<td>$col_value</td>\n";
}
print "\t</tr>\n";
}
print "</table>\n";
?>

[deleted]

Looks like you just have duplicates in your database, the code really only prints every record once...

Liquidice

I only have one record in the database. So I don't know how PHP could be outputing everything in duplicate.

scottm

Hi,

The prob, I believe, is with the fetch array. MySql delivers two sets of data arrays if you do not specify which you need or want. One array is an associated array with the key names being the field names and the other is an unassociated array which has numbers for keys. To avoid the double data, change your fetch array statement to look like this:

while ($line = mysql_fetch_array($result, ASSOC)) {

Hope this helps.🙂

Scott

[deleted]

Oh, argh!!!

I missed this one: you're using mysql_fetch_array(), and that fetches both the normal array and the associative array, so you get every field twice, once at index 0,1,2,3... and once at the index of the column-name.

Try printing the $col_name, you'll see what I mean.

Try using mysql_fetch_row or mysql_fetch_assoc() instead, that will return either the normal array or the assoc array, but not both.

Liquidice

Everybody thanks for your input. I got the script to do what I need it to do. If I have any more questions I will start another thread.

chads2k2

Originally posted by vincente
Oh, argh!!!

I missed this one: you're using mysql_fetch_array(), and that fetches both the normal array and the associative array, so you get every field twice, once at index 0,1,2,3... and once at the index of the column-name.

Try printing the $col_name, you'll see what I mean.

Try using mysql_fetch_row or mysql_fetch_assoc() instead, that will return either the normal array or the assoc array, but not both.

Is there a speed factor involved there? Speed is always good and it seems if you dont need to load everything twice then that would be faster? 😕 Ok maybe not. Hell if I know! SPEED WIZARD!

Chad

[deleted]

"Is there a speed factor involved there? Speed is always good and it seems if you dont need to load everything twice then that would be faster?"

Hardly. The data is not loaded twice, it is presented in the array twice.

Ofcourse it is slower than presenting it once, but the difference is not really noticable (unless you fetch a few thousand rows at a time)