[Resolved] [Resolved] Excluding rows to select in mysql

[keithjasper]

Me again ...

is it possiable to select data from a table i.e where dayofweek = thursday

but to exclude things from another coloum say NOT time=1pm?

<table border="1">
<tr><td>Product Code</td><td>Description</td><td>Unit</td></td><td>Quantity</td><td>Price</td></tr>
<?
$query = mysql_query("SELECT * FROM hvgOrders WHERE cartid = '$ordernumber' ");
while ($rows = mysql_fetch_array($query))
{
$total += $rows[7];
echo "<tr><td>".$rows[2]."</td><td>" .$rows[6]. "</td><td>£" .$rows[3]. "</td><td>" .$rows[5]. "</td><td>£" .$rows[7]. "</td></tr>" ;
}
?>

😃 😃

[dv6cougar]

you should just be able to use a != in your query.

so WHERE time != '1pm'
for example

[keithjasper]

im begining to like both php and phpbuilder more and more.... every problem i have you lot come up with the answer

and whenever i learn something its something which makes php easier...

!= (not equal to) works on both the php bits and mysql bits.

this site should compile a book from all of these posts.

😃