MySQL

mysql duplicate results

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Sep 2009

Posts: 19

Reputation: armyguydave69 is an unknown quantity at this point

Solved Threads: 0

armyguydave69 armyguydave69 is offline

Offline

Newbie Poster

mysql duplicate results

Sep 26th, 2009

Okay, I'm a little confused - this code works perfectly fine in mysql; however, in php it keeps repeating the first person for about 15 rows. Can someone point me to what I'm missing here.

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
$queryUsers = "SELECT user_id, zipcode, gender, housing_status, active, username FROM users WHERE user_id != '" . $_SESSION['user_id'] . "'
					AND active = 1";
	$dataUsers = mysqli_query($dbc, $queryUsers);
	$rowUsers = mysqli_fetch_array($dataUsers);
$queryUsers = "SELECT user_id, zipcode, gender, housing_status, active, username FROM users WHERE user_id != '" . $_SESSION['user_id'] . "'
					AND active = 1";
	$dataUsers = mysqli_query($dbc, $queryUsers);
	$rowUsers = mysqli_fetch_array($dataUsers);

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
echo '<table width="100%" border="0" cellspacing="0" cellpadding="0">';
	  while ($row = mysqli_fetch_array($dataUsers)) {
 
			echo '
				<tr><td class="subtitle" height="30px" colspan="3" align="left" valign="middle">' . $rowUsers['username'] . '</td></tr>
				<tr><td width="21%" rowspan="8" align="center" valign="middle"><img alt="profile picture" name="profilepic" width="100" height="100" id="profile picture" /></td></tr>
				<tr class="oddrow"><td width="21%" align="left" valign="middle">Age:</td><td width="58%">' . $rowUsers['user_id'] . '</td></tr>
				<tr class="evenrow"><td align="left" valign="middle">Gender:</td><td>' . $rowUsers['gender'] . '</td></tr>
				<tr><td align="left" valign="middle">Location:</td><td>&nbsp;</td></tr>
				<tr class="evenrow"><td align="left" valign="middle">Looking for:</td><td>' . $rowUsers['housing_status'] . '</td></tr>
				<tr><td align="left" valign="middle">Has children:</td><td>&nbsp;</td></tr>
				<tr class="evenrow"><td align="left" valign="middle">Type of pets:</td><td>&nbsp;</td></tr>
				<tr class="oddrow"><td align="left" valign="middle">Inside Smoker:</td><td>&nbsp;</td></tr>
				<tr class="subtitle"><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr>';
 
	}
	  echo '</table>';
echo '<table width="100%" border="0" cellspacing="0" cellpadding="0">';
	  while ($row = mysqli_fetch_array($dataUsers)) {

			echo '
				<tr><td class="subtitle" height="30px" colspan="3" align="left" valign="middle">' . $rowUsers['username'] . '</td></tr>
				<tr><td width="21%" rowspan="8" align="center" valign="middle"><img alt="profile picture" name="profilepic" width="100" height="100" id="profile picture" /></td></tr>
				<tr class="oddrow"><td width="21%" align="left" valign="middle">Age:</td><td width="58%">' . $rowUsers['user_id'] . '</td></tr>
				<tr class="evenrow"><td align="left" valign="middle">Gender:</td><td>' . $rowUsers['gender'] . '</td></tr>
				<tr><td align="left" valign="middle">Location:</td><td>&nbsp;</td></tr>
				<tr class="evenrow"><td align="left" valign="middle">Looking for:</td><td>' . $rowUsers['housing_status'] . '</td></tr>
				<tr><td align="left" valign="middle">Has children:</td><td>&nbsp;</td></tr>
				<tr class="evenrow"><td align="left" valign="middle">Type of pets:</td><td>&nbsp;</td></tr>
				<tr class="oddrow"><td align="left" valign="middle">Inside Smoker:</td><td>&nbsp;</td></tr>
				<tr class="subtitle"><td>&nbsp;</td><td>&nbsp;</td><td>&nbsp;</td></tr>';
		
	}
	  echo '</table>';

also if i change mysqli_fetch_array to mysqli_num_rows, I get a million empty rows.

•

Join Date: Sep 2009

Posts: 19

Reputation: armyguydave69 is an unknown quantity at this point

Solved Threads: 0

armyguydave69 armyguydave69 is offline

Offline

Newbie Poster

Re: mysql duplicate results

Sep 26th, 2009

I guess it helps if I have the variables named the same ($row = $rowUsers)...

•

Join Date: May 2008

Posts: 17

Reputation: flashyflashy is an unknown quantity at this point

Solved Threads: 2

flashyflashy flashyflashy is offline

Offline

Newbie Poster

Re: mysql duplicate results

Sep 26th, 2009

$_SESSION['user_id'] , I guess this is causing problem.
Try

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$session_user=$_SESSION['user_id'];
$queryUsers = "SELECT user_id, zipcode, gender, housing_status, active, username FROM users WHERE user_id != '" . $session_user. "' AND active = 1";
$session_user=$_SESSION['user_id'];
$queryUsers = "SELECT user_id, zipcode, gender, housing_status, active, username FROM users WHERE user_id != '" . $session_user. "' AND active = 1";

Last edited by peter_budo; Sep 27th, 2009 at 8:18 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.