Re: problem with getting info from 2 tables in PHP / MySQL
Available news archives: comp.lang.tcl - comp.lang.python - comp.security.firewalls - sci.crypt - comp.lang.php - comp.lang.javascript
Google
 
Web news.hping.org


comp.lang.php archive

Re: problem with getting info from 2 tables in PHP / MySQL

From: utque <utqsall@gmail.com>
Date: Wed Aug 03 2005 - 09:30:18 CEST



while you are accessing the sql database, try using the INNER JOIN


command.


$sql = mysql_query("SELECT * FROM logintableb INNER JOIN datatable


WHERE


logintable.school = datatable.school");



I am not sure of it but trying doesn't hurt.


Received on Mon Oct 24 02:09:13 2005