Re: [PHP-DB] SELECT LIKE with % and without %

2009-05-04 Thread Eleonora De Marinis
$sql = SELECT * FROM table WHERE ID ='$_GET[id]' AND title LIKE '%$_GET[word]%'; Original Message Subject: [PHP-DB] SELECT LIKE with %' and without %' From: Emiliano Boragina emiliano.borag...@gmail.com To: php-db@lists.php.net Date: 05/03/2009 01:43 AM Hello. I am using

Re: [PHP-DB] Problems with INNER JOIN

2009-01-29 Thread Eleonora De Marinis
Try this: $sql = SELECT admin.AdminID AS adminID, workorders.AdminID AS workadmin FROM admin INNER JOIN workorders ON (admin.AdminID=workorders.AdminID) WHERE admin.UserName = '.$_SESSION['user'].' ; maybe you have to call with different name