Query data not sorting

[Toadums]

Hey...I have had this piece of code working for about 3months, and all of a sudden it stopped working (I had it in various forms in 4 different places)...

It is supposed to run a query into my database, and select all items from the project table, in numerical order...but it doesnt like ordering them..

like I said, it has been perfect for the past 3 months, and now the past 2 days it stops working...

let me know if you have any suggestions 🙂

thanks!

						
<?php
	//Query to get all projects in the projects database
	$query="SELECT * FROM `pdem_projectss`.`tblProjects` ORDER BY `tblProjects`.`ProjectID` ASC ";
	$result=mysql_query($query);

$f='<select class="form_item" name="ProjectID" id="projID" onchange="fetchProjects(\'ajax_ts_project_query.php\',this.value,\'ts\')">';
$f.='<option value=" "></option>';

while ($row = mysql_fetch_array($result)) {
	 $f.='<option value= "'.$row['ProjectID'].'">'.$row['ProjectID']. '</option>';
}
$f.='</select>';

echo $f; 

?>
						

[prkarpi]

HI. Right off hand I see a mistake:

$query="SELECT * FROM `pdem_projectss

do this:

$query="SELECT (*) FROM `pdem_projectss

See if this works.

[Toadums]

Thats not proper sql syntax...Right in sql it says:

$query="SELECT * FROM `pdem_projectss

O.o

but I tried it anyways and I just got a query error lol..

thanks tho 🙂

[prkarpi]

I am not seeing any other mistakes. But I would suggest checking the names of the tables and comparing them to the actual tables in DB. Also, try o connect to one DB at ones and see what happens, for it seems that you are connecting to two DB at once. Also, when I said to use (*), it was my mistake. Disregard that.

[Toadums]

Ok...everything is perfect...excactly how it was the day before this error came about....so why did it decide to not sort itself?! 🙁

thanks for the suggestions tho hehe

[dagon]

A solar neutrino passing through your cpu at the time toggled a bit

[scrupul0us]

dagon;10930497 wrote:

A solar neutrino passing through your cpu at the time toggled a bit

mmm that was an excellent NOVA special