[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 li

[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

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

2003-03-12 Thread Joel Colombo
he past there are all kinds of possiblities. That should be it for the DB structure. if you are interested 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,

[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 i

[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: Array & loops

2003-03-06 Thread Joel Colombo
m] as $date_done) { echo "1. $description : $date_done"; } } That should do all that u want It will list all exam times that meet your search. Joel Colombo "Robin Sanchez" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I am creating a r

[PHP-DB] Re: Storing browser stats

2003-03-06 Thread Joel Colombo
(useragent_name) VALUES (\"$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. S

[PHP-DB] Re: Help with a query

2003-03-04 Thread Joel Colombo
d' i 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

[PHP-DB] need for mysql row combination.

2002-07-24 Thread Joel Colombo
;]; echo "$name"; } while ( $row=mysql_fetch_array($result2)) { $name = $row['name']; echo "$name"; } while ( $row=mysql_fetch_array($result3)) { $name = $row['name']; echo "$name"; } probably aint possible or more resource overhead

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 wonde