back again

dast1

Back again! Anyone have an idea of how i would perform this script below then add to the counter and perform it again and keep looping thru until the counter exceeds the id number?

<?php

require("func_connect.php");
connect ("localhost","tantrum");

session_start();

$count = "0";
$count++;

$sql = "SELECT * FROM company, products WHERE company.cid=$count AND products.cid=$count";
$result = mysql_query($sql) or die("Could not execute query.");

echo "<h1>$name</h1>";

while ($data = mysql_fetch_array($result)) {

do { 

// turn all fields in the db into variables (w/ same name as the db field)
foreach ( $data as $key => $val ) { 
$$key = $val;
}

echo "<a href=\"view_product.php?id=$id\">$title</a><br>
<a href=\"update_product.php?id=$id\">Update product info</a> :
<a href=\"delete_product.php?id=$id\">Delete product</a><br><br>";

      } while ($data = mysql_fetch_array($result));

}

mysql_free_result($result);

Any ideas would be great.
Thanks,
dast

Anon

should work like this (scratch):

$counter = 0;
$max = 100;

...

while($data = mysql_fetch_array($result) && $counter < $max)
{
...

$counter++;
}

I hope that is what you're looking for.

dast1

Definately along the right lines, thanks. I am getting a Invalid argument supplied for foreach() error. Also I dont think the sql statement is picking up the increment in the counter. Any ideas?

<?php

require("func_connect.php");
connect ("localhost","tantrum");

session_start();

$count = "1";
$max = "30";

$sql = "SELECT * FROM company, products WHERE company.cid=$count AND products.cid=$count";
$result = mysql_query($sql) or die("Could not execute query.");

echo "<h1>$name</h1>";

while ($data = mysql_fetch_array($result) && $count < $max) {

do { 

// turn all fields in the db into variables (w/ same name as the db field)
foreach ( $data as $key => $val ) { 
$$key = $val;
}

echo "<a href=\"view_product.php?id=$id\">$title</a><br>
<a href=\"update_product.php?id=$id\">Update product info</a> :
<a href=\"delete_product.php?id=$id\">Delete product</a><br><br>";

      } while ($data = mysql_fetch_array($result));

$count++;
}

mysql_free_result($result);

thanks once again!

icaro

from http://www.php.net/manual/en/function.mysql-fetch-array.php

<?php
mysql_connect("localhost", "mysql_user", "mysql_password") or
die("could not connect");
mysql_select_db("mydb");

$result = mysql_query("SELECT id, name FROM mytable");

while ($row = mysql_fetch_array($result)) {
    printf ("ID: %s  Name: %s", $row[0], $row["name"]);
}

mysql_free_result($result);

everything depends on your table where you do that select..
are you sure you need to use foreach in this case? while + mysql_fetch_array does all the work.

anyway, dont use *, use the column names in select, unless you are completely sure about the order of the fields on table.