On Aug 9, 2003, "Ryan A" claimed that: |Hi, |I am running a pretty simple statement (thanks to ben from the list) that i |have already checked via phpmyadmin, but i dont know how to display it.... | |eg: | |$tt = "SELECT COUNT(*), 'Count1' FROM shared WHERE user ='".$my_user."' and |cno=".$mmy_cno." UNION |SELECT COUNT(*), 'Count2' FROM dedicated where user='".$my_user."' and |cno=".$mmy_cno." UNION |SELECT COUNT(*), 'Count3' FROM reseller WHERE user ='".$my_user."' and |cno=".$mmy_cno." UNION | SELECT COUNT(*), 'Count4' FROM colocated WHERE user ='".$my_user."' and |cno=".$mmy_cno." UNION | SELECT COUNT(*), 'Count5' FROM freehosting WHERE user ='".$my_user."' and |cno=".$mmy_cno; | |what am i doing wrong? | |Kindly reply, |-Ryan
First, you aren't reading the manual, which has some examples. The referred page also has "See also:" with some good references. http://www.php.net/mysql_query Second, you haven't [apparently] bothered to search the web for any php/mysql tutorials. Search some good tutorial sites and they will give you some good examples of printing and of php/mysql in general. Have fun learing Jeff -- Registered Linux user #304026. "lynx -source http://jharris.rallycentral.us/jharris.asc | gpg --import" Key fingerprint = 52FC 20BD 025A 8C13 5FC6 68C6 9CF9 46C2 B089 0FED Responses to this message should conform to RFC 1855. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
