Jump to content

Bad code?


jeva39

Recommended Posts

I try to load records into a Table but repeat in the two colums the same field and only the first record. No rows for the rest of records...

For example, the first record is "A la candela" and the rhythm is "Merengue". The output is

"A la candela" "A la candela"

And repeat this record forever

You can check this at: http://www.prolatin.com/php/jv_mysql2.php


This is the code:

[code]<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>Pruebas</title>
<link rel="stylesheet" type="text/css" href="lib.css">
</head>
<body bgcolor="#FFFFFF" text="#996600" link="#996600" vlink="#996600" alink="#996600">
<table width="90%" border="1" align=center bgcolor="#FFFFFF">
<tr>
<td>
<?php
ini_set('error_reporting', E_ALL);
ini_set('display_errors', 1);
$con = mysql_connect("localhost", "username", "pass")or die('MySQL Connect Error: '.mysql_error());
mysql_select_db("jv");
$sql = "select tema,ritmo from temas order by tema";

$queryexe = mysql_query($sql);
while(mysql_fetch_row($queryexe))
    {
  $tema = mysql_result($queryexe, "tema"); 
  $ritmo = mysql_result($queryexe, "ritmo");
 
?>
  <tr>
  <td class="listas" bgcolor="#f7efde"> <?php print ("$tema"); ?></td>
  <td class="listas" bgcolor="#f7efde"> <?php print ("$ritmo"); ?></td>
  </tr>
<?php }
  echo "Error: " . mysql_error();
?>
</td>
</tr>
</table>                                       
</body>
</html> [/code]
Thanks for your help!!!
Link to comment
Share on other sites

The only part of your code that is unfamiliar to me in syntax is:

[quote]$queryexe = mysql_query($sql);
while(mysql_fetch_row($queryexe))
    {
  $tema = mysql_result($queryexe, "tema"); 
  $ritmo = mysql_result($queryexe, "ritmo");[/quote]

I usually would write this for mysql_fetch_row:

[quote]$queryexe = mysql_query($sql);
while(list($tema, $ritmo) = mysql_fetch_row($result))
{
echo '
  <tr>
  <td class="listas" bgcolor="#f7efde"> ' . $tema . '</td>
  <td class="listas" bgcolor="#f7efde"> ' . $ritmo . '</td>
  </tr>';
}
[/quote]

Maybe this will help?  I know it is irrational, but I always avoid escaping out of php in the middle of a query because it always seems to cause problems for me.  Mostly, though, try the while(list() syntax.


Wendy
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.