Help with &quot;While&quot; function

Help with "While" function

r_sole

Okay this should be pretty simple for someone whose a bit more familiar with php (I'm guessing)..

I have a table with 2 rows.
1 of the rows is an integer. The integer is chosen from a list in a previous page/form.
The other row is just a string of text.

My question is this.
How can I use the while (or any) function to echo these integers in numerical order. As in go through the rows, and just echo all the rows with a value of "1". Then go through again, listing only the rows with a value of "2". Etc.

I'm guessing it would be using the loop function or something.. I dunno.

(P.S are these - while, loop, etc - called functions. I'm just calling them that)

I'm pretty noob. 🙂

r_sole

Nevermind. With a bit of guess and check I figured it out. I had to use for and while:

$result = mysql_query("SELECT * FROM Categories");

for($i = 0; $i==$row['ID']; $i++){
while($row = mysql_fetch_array($result))
{
echo $row['ID']
}
}

r_sole

Nope. I checked it and that's not it actually.

I'm still needing help with this.

r_sole

Okay. I got it. I had to do 2 things. The first "while" to find out the highest number in the table. Then a "for" to count through that many times.

$result = mysql_query("SELECT * FROM Categories");

$i=0;

while($row = mysql_fetch_array($result))
{
if($i<$row['ID']){
$i++;
}
}

$result = mysql_query("SELECT * FROM Categories");

for($ii = 0; $ii<$i; $ii++)
{
$row = mysql_fetch_array($result);
echo "blah blah";
}

Not that anyone cares.

Weedpacket

You could also look at using the COUNT function and/or the ORDER BY clause in your query.

r_sole

Thanks. Yes ORDER BY helps a lot.

.. and yeah it turned out that other code I wrote doesn't work.

r_sole

Okay I finally got it.

$result = mysql_query("SELECT ID FROM Categories ORDER BY ID ASC LIMIT 1");
while ($row = mysql_fetch_assoc($result)) {
$l = $row['ID'];
}

$result = mysql_query("SELECT * FROM Categories ORDER BY ID ASC"); // ???

echo "blah"

while ($row = mysql_fetch_assoc($result)) {
if($row['ID']>$l){
$l++;
echo "blah"
}

?>

barand

Are you trying to get counts of the rows with each value?

$sql = "SELECT id, COUNT(*) as tot
FROM Categories
GROUP BY id";
$res = mysql_query($sql);
while (list ($id, $tot) = mysql_fetch_row($res)) {
echo "$id : $tot <br>";
}

r_sole

This is what it's for:

http://vanilanila.com/notebooks/index.php

How it basically works is a text box takes what you write and stores it in a database with an "id number".

But on the same page it also displays all these different blocks of text, categorically, by their "id number".

But I found the second part tricky.. it's hard to take the text, and the "id numbers", and make it look like it does...

This is how I did it, but I'd love to hear of a simpler or better way...

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<div style="text-align:center;">
<div style="text-align:center; font-size:36px; text-decoration:underline"> Notes: </div>
<br />
<div><form action="submit.php" method="post">
<div>
<input type="text" style="width:400px;" name="notes" />
<input name="category" type="hidden" value="0" />
</div>
<div>

<br  />
<br />

<div style=" font-size:36px; text-decoration:underline;">Category: <a style="font-size:18px;" href="edit.php" />(edit)</a></div>

<br />

<?php

$con = mysql_connect ("localhost","USERNAME","PASSWORD");	// ready db connect

if(!$con){
	die("could not connect". mysql_error());
}

mysql_select_db("vanilani_notebooks",$con); // execute connect and select db

// Find highest ID number -- for when selecting/making the "new category"
$result = mysql_query("SELECT ID FROM Categories ORDER BY ID DESC LIMIT 1"); 
while ($row = mysql_fetch_assoc($result)) {
	$h = $row['ID'];
}

// Find lowest ID number - to use to know when the ID's in the DB table has increased (and to <br /> and echo the next numbe)
$result = mysql_query("SELECT ID FROM Categories ORDER BY ID ASC LIMIT 1");
while ($row = mysql_fetch_assoc($result)) {
	$l = $row['ID'];
}

$result = mysql_query("SELECT * FROM Categories ORDER BY ID ASC"); // ???

if (isset($l)){ // check if $l (the lowest number ID actually exists)
echo "<span style='font-size:100px;'>".$l."</span>";
echo "<input type='radio' name='ID' value='".$l."' />";
echo "<br />";
}

while ($row = mysql_fetch_assoc($result)) {
	 if($row['ID']>$l){ 
	 $l++; 
	 echo "<br />"; 
	 echo "<span style='font-size:100px;'>".$l."</span>";
	 echo "<input type='radio' name='ID' value='".$l."' />";
	 echo "<br />";
	 }
	echo $row['string']."<br /> <br /> ";
}


?>

<br />

<span style="font-size:100px;">(new category)</span>
<input type="radio" name="ID" value="<?php $h+=1; echo $h; ?>" />
<br /><br />
<input type="submit" value="Select category and submit" />
</div>
</form>

</body>
</html>

My way seems a bit messy. I did it with basically guess and check.