HELP with a mysql_fetch_array loop pls!!!

[TheStalker]

Hi all,

ok, i have a database table with cars and dates they are booked out on. What i want to do is query the table and display a list of available for a date that is entered.

My problem is with my loop it loops though a number of times but cant work out where im going wrong. It might be easier to understand when u look at the code.

database entry example:

date - 27/03/2010
car - car1

date - 27/03/2010
car - car 4

PHP code

$sql = mysql_query("SELECT * FROM bookings WHERE datebooking ='".$date."' ");


echo "<ul>";
		while ($row = mysql_fetch_array($sql))
		{

		if ($row['car'] != "car1" )
		{
			echo "<li>car1</li>"; 
		}
		if ($row['car'] != "car2")
		{
			echo "<li>car2</li>";
		}
		if ($row['car'] != "car3")
		{
			echo "<li>car3</li>";
		}
		if ($row['car'] != "car4")
		{
			echo "<li>car4</li>";
		}
		if (trim($row['car']) != "car5")
		{
			echo "<li>car5</li>";
		}


	}
echo "</ul>";

this gives the wrong result it loops and print the result twice and wrong.
Hope this give an idea of what im trying to do.

any help would be great.

[seco]

so you want to just show the car that are associated with the date entered?

try this

<?php

//Database Information

$dbhost = "localhost";
$dbname = "car";
$dbuser = "root";
$dbpass = "";

//Connect to database

mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());

?>
<form action="" method="post">
<input name="date" type="text" /><input name="submit" type="submit" value="submit" />
</form>
<?php
if(isset($_POST['submit'])){
$date = $_POST['date'];

$sql = "SELECT * FROM bookings WHERE datebookings='$date'";

$result = mysql_query($sql) or die(mysql_error());

echo "<ul>";
        while($row = mysql_fetch_array($result))
		{
          echo "<li>".$row['car']."</li>";  

        }
    echo "</ul>"; 
	}
?>

[TheStalker]

thanks for your reply.

no what i would like to do is show the cars that are not booked out so the cars that are not associated with the date.

[seco]

Try this then

$date = $_POST['date'];

$sql = "SELECT * FROM bookings ORDER BY datebookings ASC";

$result = mysql_query($sql) or die(mysql_error());

echo "<ul>";
        while($row = mysql_fetch_array($result))
		{
		  if ($row['datebookings'] == $date){
          //echo "<li>".$row['car']." - Out</li>"; 
		  }else{
		  echo "<li>".$row['car']." - Available</li>";  

		  }
        }
    echo "</ul>"; 
	}

you can uncomment the Out echo to show the cars out aswell.

[TheStalker]

seco;10924468 wrote:

Try this then

$date = $_POST['date'];

$sql = "SELECT * FROM bookings ORDER BY datebookings ASC";

$result = mysql_query($sql) or die(mysql_error());

echo "<ul>";
        while($row = mysql_fetch_array($result))
		{
		  if ($row['datebookings'] == $date){
          //echo "<li>".$row['car']." - Out</li>"; 
		  }else{
		  echo "<li>".$row['car']." - Available</li>";  

		  }
        }
    echo "</ul>"; 
	}

you can uncomment the Out echo to show the cars out aswell.

Hi thanks for our reply again. The problem with the above code si that i might have 100 enterys in my database

date, car booked

This would then echo out all the other cars corresponding to other dates.

there are 5 cars car1 car2 car3 car4 and car 5

each database record has a date and the name of the car

so it might look like this

30/01/2010 - car1
27/03/2010 -car3
27/03/2010 - car4
04/05/2010 - car1
06/06/2010 -car5
06/06/2010 - car4

and so on

So what i want to do is when the date say 06/06/2010 is entered the list would show:

car1
car2
car3

if the date 04/05/2010 was entered the list would show

car2
car3
car4
car5

[Bjom]

... WHERE datebooking != '2010-06-06';

See here