PHP Forum

**Hawkallica** · 03-17-2005, 09:58 PM

I have made an order form for people out-of-state to order my band's demo. its at http://www.HAVOKband.com/demo.php

I am trying to make an admin control panel, and I am trying to do it so it prints all of the info, row by row. I am a n00b when it comes to php, and I got some help from a friend, and what I have so far is this:

PHP Code:


			
<?php

print("<HTML><HEAD><TITLE>HAVOKband.com</TITLE></HEAD><BODY>");

include("connect.php"); 



$id = 1;    



$prepmaxid = mysql_query("SELECT id FROM havokban_site WHERE max(id)");

$maxid = mysql_result($prepmaxid,"maxid");

        

print("<TABLE border=0>");

while($id < $maxid) {

    

    $querystring = mysql_query("SELECT id ,fname, lname, email, sadrs, city, state, zip, phone, price, item, size FROM havokban_site WHERE id = '$id'");

    $datarow = mysql_fetch_array($querystring);

    

    if($datarow['fname'] != NULL) {

        

        print("<TR><TD>" . $datarow['id'] . "</TD><TD>" . $datarow['fname'] . "</TD><TD>" . $datarow['lname'] . "</TD><TD>" . $datarow['email'] . " </TD>");

        print("<TD>" . $datarow['sadrs'] . "</TD><TD>" . $datarow['city'] . "</TD><TD>" . $datarow['state'] . "</TD><TD>" . $datarow['zip'] . "</TD>");

        print("<TD>" . $datarow['phone'] . "</TD><TD>" . $datarow['price'] . "</TD><TD>" . $datarow['item'] . "</TD><TD>" . $datarow['size'] . "</TD></TR>");

        $id = $id + 1;

    

    }

    else {

        

        print("This is where its ****ing up");

        $id = $id + 1;

    

    }

    

}

print("</TABLE>");

print("Loop End");

print("</BODY></HTML>");

?>

Can someone please help me with this? Its not working correctly, I dont know why.

The link to it is here:

http://www.HAVOKband.com/list.php

Thanks for your time

**Anacrusis** · 03-17-2005, 10:59 PM

Your query:
"SELECT id ,fname, lname, email, sadrs, city, state, zip, phone, price, item, size FROM havokban_site WHERE id = '$id'");

is not returning any rows. Where is $id being set?

**Hawkallica** · 03-18-2005, 07:12 AM

I thought this would do it,
set id to one:

$id = 1;

and id is a field in my database, and it finds the maximum value of id:
$prepmaxid = mysql_query("SELECT id FROM havokban_site WHERE max(id)");