Hi guys - It has been a few years since I have coded in PHP and I need a little help. I wrote down an example snippet below...I don't remember how to get more than one result out of the code (I think that these are called arrays) ...
$results1=@("SELECT * FROM jobsdata WHERE categoryid='45'");
$result2=@mysql_fetch_array($result1);
if($totalprojects==0)
{
echo "<b>Sorry - Nothing Available</b>";
}
else
{
while($totalprojects > 0)
{
$id = $results2['id'];
$name = $results2['name'];
$phone = $results2['phone'];
$street = $results2['street'];
echo $id;
echo $name;
echo $phone;
echo $street;
}
If I have about 60 records in the database, I only get 1 record out of this array, how do I get all of the data out instead of just one set?
Thank you for your help.
