make multiple colums of records.

[npereira]

I am trying to have my records show up in more than 1 column so the page is shorter in lenght.

What am i missing here?

	printf("<tr><td>%s %s</td></tr>", $myrow["nom"], $myrow["prenom"]);

Thanks for your help in advance.

Npereira

[juschillinnow]

print("<table><tr>");
$totalcols = 3;
$colsprinted = 0;
while($row = mysql_fetch_row($mysql_result) //replace with your variables
{
if($totalcols == $colsprinted)
{
print("</tr><tr>");
$colsprinted = 0;
}
else
{
printf("<td>%s %s</td>", $myrow["nom"], $myrow["prenom"]);
$colsprinted++;
}
}

print("</tr>");

[npereira]

here is what it looks like , but there is a major error somewhere.

mysql_select_db("dblesailerons",$db);

if ($submit) {

  // here if no ID then adding else we're editing

  if ($id) {

$sql = "UPDATE membres SET nom='$nom',prenom='$prenom',adresse='$adresse',telephone='$telephone',fréquence='$fréquence',email='$email' WHERE id=$id";

  } else {

$sql = "INSERT INTO membres (nom,prenom,adresse,telephone,fréquence,email) VALUES ('$nom','$prenom','$adresse','$telephone','$fréquence','$email')";

  }

  // run SQL against the DB

  $result = mysql_query($sql);

  echo "Ce membre a été mise-à-jour!<p>";

} elseif ($delete) {

    // delete a record

$sql = "DELETE FROM membres WHERE id=$id";

$result = mysql_query($sql);

echo "Ce membre a été éffacé!<p>";

} else {

  // this part happens if we don't press submit

  if (!$id) {

// print the list if there is not editing

$result = mysql_query("SELECT * FROM membres ORDER BY nom ASC",$db);

print("<table><tr>");
$totalcols = 3;
$colsprinted = 0;
    while ($myrow = mysql_fetch_array($result)) 
{
if($totalcols == $colsprinted)
{
print("</tr><tr>");
$colsprinted = 0;
}
else
{
printf("<td>%s %s</td>", $myrow["nom"], $myrow["prenom"]);
$colsprinted++;
}
}

print("</tr>");

echo "</table>\n";

}

  }

  ?>

[juschillinnow]

Try this. You forgot a line after the $result. Take a look. You can also replace 'nom' and 'prenom' with number like '0' and '1'

Originally posted by npereira
here is what it looks like , but there is a major error somewhere.

mysql_select_db("dblesailerons",$db);

if ($submit) {

  // here if no ID then adding else we're editing

  if ($id) {

$sql = "UPDATE membres SET nom='$nom',prenom='$prenom',adresse='$adresse',telephone='$telephone',fréquence='$fréquence',email='$email' WHERE id=$id";

  } else {

$sql = "INSERT INTO membres (nom,prenom,adresse,telephone,fréquence,email) VALUES ('$nom','$prenom','$adresse','$telephone','$fréquence','$email')";

  }

  // run SQL against the DB

  $result = mysql_query($sql);

  echo "Ce membre a été mise-à-jour!<p>";

} elseif ($delete) {

    // delete a record

$sql = "DELETE FROM membres WHERE id=$id";

$result = mysql_query($sql);

echo "Ce membre a été éffacé!<p>";

} else {

  // this part happens if we don't press submit

  if (!$id) {

// print the list if there is not editing

$result = mysql_query("SELECT * FROM membres ORDER BY nom ASC",$db);
$mysql_result = mysql_query($result);

print("<table><tr>");
$totalcols = 3;
$colsprinted = 0;
    while ($myrow = mysql_fetch_row($mysql_result)) 
{
if($totalcols == $colsprinted)
{
print("</tr><tr>");
$colsprinted = 0;
}
else
{
printf("<td>%s %s</td>", $myrow["nom"], $myrow["prenom"]);
$colsprinted++;
}
}

print("</tr>");

echo "</table>\n";

}

  }

  ?>

[/B]

[npereira]

I have simplefied the script cause im all messed up here.
Something here is wrong. I don't know where to look.

<?php

$db = mysql_connect("localhost", "db", "pass");

mysql_select_db("dblesailerons",$db);

$result = mysql_query("SELECT * FROM membres ORDER BY nom ASC",$db);

$mysql_result = mysql_query($result);

print("<table><tr>");
$totalcols = 3;
$colsprinted = 0;
    while ($myrow = mysql_fetch_row($mysql_result)) 
{
if($totalcols == $colsprinted)
{
print("</tr><tr>");
$colsprinted = 0;
}
else
{
printf("<td>%s %s</td>", $myrow["nom"], $myrow["prenom"]);
$colsprinted++;
}
}

print("</tr>");

echo "</table>\n";

  ?>

[juschillinnow]

use this

<?
$mysql_link = mysql_connect("localhost", "username", "password")
or die
("<p>Could not connect to the database!");
mysql_select_db("dblesailerons", $mysql_link)
or die
("<p>Could not open the database!");
?>

save this file as dbconnect.php in the same folder that you are creating this file. It will simplify things for you.

and then just include it in all your file like this:

<?php
include("dbconnect.php");
$query = "SELECT * FROM membres ORDER BY nom ASC";
$mysql_result = mysql_query($query, $mysql_link);
print("<table><tr>");
$totalcols = 3;
$colsprinted = 0;
    while ($myrow = mysql_fetch_row($mysql_result)) 
{
if($totalcols == $colsprinted)
{
print("</tr><tr>");
$colsprinted = 0;
}
else
{
printf("<td>%s %s</td>", $myrow[0], $myrow[1]);
$colsprinted++;
}
}

print("</tr>");

echo "</table>\n";
  ?>

This should be the whole code if you do it right. If it does not work please include the error and what is happening

[npereira]

Here is what it looks like.

<?php
include("dbconnect.php");
$query = "SELECT * FROM membres ORDER BY nom ASC";
$mysql_result = mysql_query($query, $mysql_link);
print("<table cellpadding=1 cellspacing=1 border=5><tr>");
$totalcols = 3;
$colsprinted = 0;
    while ($myrow = mysql_fetch_row($mysql_result)) 
{
if($totalcols == $colsprinted)
{
print("</tr><tr>");
$colsprinted = 0;
}
else
{
printf("<td>%s %s</td>", $myrow[1], $myrow[2]);
$colsprinted++;
}
}

print("</tr>");

echo "</table>\n";
  ?>

Now, I would like to add a radio button so I can select that record and modify it or delete it.

[juschillinnow]

I assume that worked for you. What you want now is a whole 'nother story. I am at work and am going home right now. When I get there I'll see if I can reply then but just to give you an idea assuming you have a form already....

Originally posted by npereira
Here is what it looks like.

<?php
include("dbconnect.php");
print("<form action =\"$PHP_SELF\" name=\"myForm\" method=\"post\">");
$query = "SELECT * FROM membres ORDER BY nom ASC";
$mysql_result = mysql_query($query, $mysql_link);
print("<table cellpadding=1 cellspacing=1 border=5><tr>");
$totalcols = 3;
$colsprinted = 0;
$numberUp = 0;
    while ($myrow = mysql_fetch_row($mysql_result)) 
{
if($totalcols == $colsprinted)
{
print("</tr><tr>");
$colsprinted = 0;
$numberUp++;
}
else
{
printf("<td><input type = \"radio\" value=\"%s[$numberUp]\">%s %s</td>", $myrow[0], $myrow[1], $myrow[2]); // This will give you the Row ID  and a numberUP value which the number will increase everytime it makes a loop. You will have to take those values and apply it to your interceptor.
$colsprinted++;
$numberUp++;
}
}

print("</tr>");

echo "</table>\n";
  ?>

Now, I would like to add a radio button so I can select that record and modify it or delete it. [/B]

Chow for now

-juschillin

[npereira]

juschillinnow

Holly crap!

This is alot harder than I thought. I'm leaving work to go home also. I'll check back later after diner.

Later.

How is this for a form?

  <form>
  <b>Nom:</b><input type="Text" name="nom" value="<?php echo $nom ?>"><br>
  <b>Prénom:</b><input type="Text" name="prenom" value="<?php echo $prenom ?>"><br>
  <b>Adresse:</b><input type="Text" size="50" name="adresse" value="<?php echo $adresse ?>"><br>
  <b>Téléphone:</b><input type="Text" name="telephone" value="<?php echo $telephone ?>"><br>
  <b>Fréquence:</b><input type="Text" name="fréquence" value="<?php echo $fréquence ?>"><br>
  <b>Email:</b><input type="Text" name="email" value="<?php echo $email ?>"><br>
  <input type="Submit" name="add" value="Ajouter le membre">
<input type="Submit" name="save" value="Sauvegarder l'information">
<input type="Submit" name="delete" value="Effacer">
  </form>

[juschillinnow]

This may not be all correct but hopefully you get the jist of what you need to accomplish:

<html>
<body>
<?php
include("dbconnect.php");
if($go == 'Get Going') //Waits for someone to hit the submit button
{
$numberLow = 0;
while($numberLow <= $numberUp)
{

$numberId = ${radio}.[$numberLow]; //You may have to play with this but I think that how.
if($numberId != '')
{
$query = "select * from DB where yourIDColumn = '$numberLow'";
$mysql_result = mysql_query($query, $mysql_link);
while($row = mysql_fetch_row($mysql_result))
{
printf("%s - %s", $row[1], $row[2]) //These should be the ones you checked
}
}
$numberLow++;
}
}
else //executes when the page loads from here to end
{
print("<form action =\"$PHP_SELF\" name=\"myForm\" method=\"post\">");
$query = "SELECT * FROM membres ORDER BY nom ASC";
$mysql_result = mysql_query($query, $mysql_link);
print("<table cellpadding=1 cellspacing=1 border=5><tr>");
$totalcols = 3;
$colsprinted = 0;
$numberUp = 0;
    while ($myrow = mysql_fetch_row($mysql_result)) 
{
if($totalcols == $colsprinted)
{
print("</tr><tr>");
$colsprinted = 0;
$numberUp++;
}
else
{
printf("<td><input type = \"radio\" value=\"radio[%s]\">%s %s</td>", $numberUp, $myrow[1], $myrow[2]); 
$colsprinted++;
$numberUp++;
}
}

print("</tr>");
printf("<input type=\"hidden\" name=\"numberUp\" value=\"%s\">", $numberUp);
printf("<tr><td><input type=\"submit\" name=\"go\" value=\"Get Going\"></td></tr>");
print("</form>");
}
?>


</body>
</html>

[npereira]

I'm getting an error;

Parse error: parse error in /usr/local/psa/home/vhosts/lesailerons.net/httpsdocs/membres/test.php on line 11

The line 11 is :

$numberId = ${radio}.[$numberLow];

[juschillinnow]

I'm not sure what the correct syntax is for this but I know its something like that. Mess around with it and change the brackets around.

Maybe its'

$numberId = ${'radio'}.[$numberLow];

or something like that

[npereira]

I've started another thread since this topic is basicaly resolved. The members show up in the table with 3 columns.

Look at my other thread.

New thread

I cannot find what the proper syntax is anyway!