[SOLVED] ORDER BY - Newbie help

[d_rewb]

Hi guys,

 

I am new to the php and msql, so any help would be gratefully appreciated.

 

Okay I am trying to add an ORDER BY to the statement below but after trying everything i know how all i keep getting an errors, would anyone know where to insert this please.

Here is the code:

 

<?php

include "config.php";

 

$sql=mysql_query("select * from event_db where eddate like '".$keyword."%'", $con);

 

$numrows= mysql_num_rows($sql);

 

if($numrows==0)

{

print ("<center><span class='style15'>No Events in $keyword.</span></center>");

 

}

else

{

while($row=mysql_fetch_array($sql))

{

$id = $row["eid"];

$dismonth = $row["eddate"];

$name = $row["ename"];

$description = $row["edesc"];

$date = $row["edate"];

$location = $row["eloc"];

$showtime = $row["eshow"];

$price = $row["eprice"];

$contact = $row["econt"];

$website = $row["eweb"];

$sdate = $row["esdate"];

list($startyear,$startmonth,$startday) = explode("-",$sdate);

$edate = $row["eedate"];

list($endyear,$endmonth,$endday) = explode("-",$edate);

$image = $row["eimage"];

?>

 

What i am trying to have are the records shown in ascending order by date.

 

thanks again

 

d_rewb

[dadamssg]

$sql=mysql_query("select * from event_db where eddate like '".$keyword."%'" ORDER BY eddate ASC, $con);

[d_rewb]

hi,

 

thanks I tried that and it displayed an error "Wrong parameter count for mysql_query() "

 

thanks

 

d_rewb

[PFMaBiSmAd]

It would really help if you posted your query where you attempted to use ORDER BY (for all we know where you put it in the query is what caused the problem) and post the error you were getting (for all we know it had nothing to do with using ORDER BY.)

[patrickmvi]

Try it like this:

 

$sql=mysql_query("select * from event_db where eddate like '".$keyword."%' ORDER BY edate ASC", $con);

[loushou]

quotes will get you everytime

[d_rewb]

Thanks for all your responses.

 

patrickmvi: I have just tried that and it seems to be working. I will try it on another page and if all goes well I will close the topic.

 

Thanks again for all your responses.

[aschk]

A tip for spreading code readability.

Try this instead:

 

<?php
// Query with replacement token(s).
$query = "SELECT * 
          FROM event_db 
          WHERE eddate LIKE '%s%%' 
          ORDER BY edate ASC";

// Query with parameters.
$query = sprintf($query, $keyword);

// Query execution.
$sql=mysql_query($query, $con);

?>