Strange Error on working PHP

[Xenon]

perhaps because you don't use a where in the query

this would be right:

$search=$DB_site->query("SELECT linkid,catagoryid,linkname,linkdesc FROM gportal_weblinkslink WHERE $condition ORDER BY linkname");

[Entourage]

thnx ppl it works now, stupid mistake of me

[DrkFusion]

Originally posted by Xenon
perhaps because you don't use a where in the query

this would be right:

$search=$DB_site->query("SELECT linkid,catagoryid,linkname,linkdesc FROM gportal_weblinkslink WHERE $condition ORDER BY linkname");

Now I get

Database error in vBulletin 2.2.8:

Invalid SQL: SELECT linkid,catagoryid,linkname,linkdesc FROM gportal_weblinkslink WHERE ORDER BY linkname
mysql error: You have an error in your SQL syntax near 'ORDER BY linkname' at line 1

mysql error number: 1064

Date: Monday 14th of October 2002 03:23:35 PM
Script: http://www.noxmedia.net/support/support/links.php
Referer: http://www.noxmedia.net/support/links.php?action=search

Thanks for your continued support.
I don't know what the problem is :cry:

Thanks in Advance
-Arunan

[DrkFusion]

Nm, got it to work, thanks Xenon!

[Xenon]

you're welcome