[PHP-DB] php5 coding class objects best practices

hi people, i havent used thi slist for quite a while. anyway. Im trying to write an application which relies heavily on mysql. so i have made a class object which has all the functions to make using mysql very easy for me. but the problem im faced with now is, i have a bunch of other classes, wh

Re: [PHP-DB] Theory help needed

i'm not experienced so this is just a theory. if you have a parent id field in your tables then each reply would have the parent id of the original message they replied to, so when your program gets the data it will get the original message, and then get any other messages with the same parent id,

[PHP-DB] net cafe software

Hi, I'm looking for some net cafe style software written in PHP, which would preferably use MySQL if it must use a database, which can track the data each client downloads instead of tracking the amout of time the client is online. Ideally the software would distinguish one client from another by e

RE: [PHP-DB] php session

On Mon, 2002-12-02 at 02:43, John W. Holmes wrote: > > No, it shouldn't. > > So, the links are correct on one page, and they disappear on the second > page? Is there a reason you're passing the SID in the URL and not using > cookies? > > Hmmm, found this in the manual. Maybe it applies? > > --

[PHP-DB] php session

hi people, I'm having a little trouble getting sessions to work properly with php. I have put session_start(); on all pages before any data is printed. The session will start on the first loading of the page but after a link is clicked the session seems to die i have no idea why. for the links on

Re: [PHP-DB] Resource id #2

You need to put your $result into an array. you can use: $result_array = mysql_fetch_array($result); then, if you know the field names in the array, print them like so: echo $result_array["field1"]; echo $result_array["field2"]; or if you dont know their names you can refer to their position nu

[PHP-DB] error 1100

Hi people, I dont know why but am stuck trying to debug this problem. I keep getting error number 1100 (Table 'jobs' was not locked with LOCK TABLES) from PHP when i try querying a mysql database. It has me stumped because I am using the LOCK TABLES statement when locking the tables...but maybe the

RE: [PHP-DB] LIKE statement or IN statement?

;); <-- im not too sure of this, would the > experts please shed some more light on this one if its correct? > > Amit > > On 4 Nov 2002, Chris Barnes wrote: > > > Hi, > > I've got a dilly of a problem. I'm probably doing something wrong but

[PHP-DB] LIKE statement

Hi, I've got a dilly of a problem. I'm probably doing something wrong but I don't know what. I'm trying to use the LIKE statement in a query where more than one word is used in with LIKE..e.g. select count(distinct itemid) from business where name or description like 'word1 word2 word3%' The prob

RE: [PHP-DB] PHP in Database Fields..

eval() might do what your asking for. I'm no expert tho. -Original Message- From: Matthew Tedder [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 25 June 2002 7:32 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP in Database Fields.. Question: I want to put PHP code into database fields ho

RE: [PHP-DB] Question

i dont know how will this will work, but you could try storing the multiple hard disk details for each computer in an "array" in 1 field. then when you want to get the information from the db, use explode() to store the value in the field into an array again. e.g. the field in the DB might look l

[PHP-DB] question from newbie

k for me? any help very much apreciated :) Chris Barnes -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Problem w/ mysql_pconnect

Hi Paul, I'm no MySQL expert and i'm only very new to this list but i have had the same problem before. What i did to fix the problem was replace "localhost" with the ip address of the machine...so on my network i my MySQL server is 10.3.2.1 so i used "10.3.2.1" instead of "localhost" and it worke