[PHP-DB] Re: Listing Tables

2003-03-15 Thread Joel Colombo
http://us2.php.net/manual/en/function.mysql-list-tables.php http://us2.php.net/manual/en/function.mysql-list-fields.php you should really check the manuals before posting... they are built right in... Joel Shaun [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, i would like to

[PHP-DB] Re: some php and database questions!

2003-03-12 Thread Joel Colombo
in my basic design there. drop me a private Email for some more. if not good luck, sounds like a cool project. Joel Colombo [EMAIL PROTECTED] Webdevil Studios Buffalo, NY Jerry [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, I am currently running a tipping

[PHP-DB] Re: Cropped Text

2003-03-12 Thread Joel Colombo
i believe u mean the dictionary term. not PHP function. Truncating Joel Dallas Freeman [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I dunno what it is called so that is why I am asking, so that I can search the web about it. What do you call the method of cropping text back, so

[PHP-DB] Re: MySQL JOIN problem

2003-03-11 Thread Joel Colombo
too busy or lazy to write it out right now but hereTaken from page : http://www.mysql.com/doc/en/JOIN.htmlmysql SELECT table1.* FROM table1 -LEFT JOIN table2 ON table1.id=table2.id -WHERE table2.id IS NULL; This example finds all rows in table1 with an id value that is

[PHP-DB] Re: explode string variable

2003-03-08 Thread Joel Colombo
or just : $word = James-Martin-Smith $word_break = Array(); $first_dash = strpos($word, '-'); if ($first_dash !== false) { $word_break[0] = substr($word,0,$first_dash+1); $word_break[1] = substr($word,$first_dash+1,strlen($word)); } André Sannerholt [EMAIL PROTECTED] wrote in

[PHP-DB] Re: Storing browser stats

2003-03-06 Thread Joel Colombo
(\$browser\); mysql_query($sql, $link_id); Simple as that Joel Colombo Bruce Levick [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Is there a method for storing each users browser stats within a database table. So everytime someone visits the browser info is gathered

[PHP-DB] Re: Array loops

2003-03-06 Thread Joel Colombo
all exam times that meet your search. Joel Colombo Robin Sanchez [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I am creating a results page for completed and uncompleted procedures. I am repeating a lot of the code and wonder if there is an easier way to do this. $neh=select

[PHP-DB] Re: Help with a query

2003-03-04 Thread Joel Colombo
guess u could give it a try. just a simple 2 table join. i may not have the fields and order in place but try it Joel Colombo Jonathan Villa [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I can't figure this query out. I want to pull data from 2 tables but using a primary key from

Re: [PHP-DB] Adding up the RESULT

2002-04-17 Thread Joel Colombo
ok i thought the SUM only worked with GROUP BY shit... that makes me feel stupid but smarter now thanx Joel Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED]... On Thursday 18 April 2002 00:08, Joel Colombo wrote: i was wondering about a PHP function like