Re: [PHP-DB] How to display table columns

2004-04-25 Thread John W. Holmes
andy amol wrote: hi, I want to display the table coulumns along with those values below it. I am only able to display the table values, now I want to diplay the corresponding table attribut above the value. eg : name age sex abc1m xyz 2f I

Re: [PHP-DB] How to display table columns

2004-04-25 Thread Marcjon Louwersheimer
Well, you would create a table like this echo "nameagesex"; Then, you would do a query (assuming you've already made a connection to your database)... $result = mysql_query("SELECT name,age,sex FROM database.usertable"); Then, run through the results... while ($row = mysql_fetch_assoc($result)

[PHP-DB] Re: How to display table columns

2004-04-25 Thread Andy Ladouceur
I think what you may be looking for is the DESCRIBE command. It allows you to get information about table columns. http://dev.mysql.com/doc/mysql/en/DESCRIBE.html Andy Andy Amol wrote: hi, I want to display the table coulumns along with those values below it. I am only able to display the tab

[PHP-DB] How to display table columns

2004-04-25 Thread andy amol
hi, I want to display the table coulumns along with those values below it. I am only able to display the table values, now I want to diplay the corresponding table attribut above the value. eg : name age sex abc1m xyz 2f I want to displa

RE: [PHP-DB] Re: Using $_SESSION array for large number of variables. Any recommendations?

2004-04-25 Thread Peter Lovatt
Hi, I would suggest a mysql table for the data. For large amounts it is probably more efficient - not sure how much resource is needed to manage 100K pieces of information using $_SESSION, but an indexed mysql table is probably much quicker. table CREATE TABLE `session_data` ( `userID` VARCHAR(

Re: [PHP-DB] Re: Using $_SESSION array for large number of variables. Any recommendations?

2004-04-25 Thread Kelly Hallman
Apr 25 at 7:48pm, Jimmy Brock wrote: > I would recommend cookies, not session. > > Cookies are stored on the users machine, whereas session data is stored on > the server. If you have a power failure or have to reboot the server session > data will be lost -- since session data is stored in memory

[PHP-DB] Re: Using $_SESSION array for large number of variables. Any recommendations?

2004-04-25 Thread Jimmy Brock
I would recommend cookies, not session. Cookies are stored on the users machine, whereas session data is stored on the server. If you have a power failure or have to reboot the server session data will be lost -- since session data is stored in memory. "Ross Honniball" <[EMAIL PROTECTED]> wrote i

[PHP-DB] RE: stuck on stupid...can't find the bloody error..

2004-04-25 Thread J. Alejandro Ceballos Z.
Isnt easy to use if (! $page_req) or if (strcmp($page_req,"0")) instead of if ($page_req == "") or if ($page_req == "0") ? -- saludos, J. Alejandro Ceballos Z. | ---+--- http://alejandro.ceballos.info | [EMAIL PROTECTED]

[PHP-DB] Re: stuck on stupid...can't find the bloody error...

2004-04-25 Thread Andy Ladouceur
Dan Bowkley wrote: else { $query_insert = "INSERT INTO boards (wo_num, name, phone, email, date, board_type, last_three, weight_in, weight_out) VALUES (\'$wo_num\', \'$name\', \'$phone\', \'$email\', \'$date\', \'$board_type\', \'$last_three\', \'$weight_in\', \'$weight_out\')"; No need to esca

[PHP-DB] Using $_SESSION array for large number of variables. Any recommendations?

2004-04-25 Thread Ross Honniball
Hi all, System : Windows XP / Apache / MySql / PHP I'm considering using session variables to store a large amount of data. How much is 'large'? To be honest, I have no idea at this point - very early days. For arguments sake, lets say the system consisted of 100 users who will all store betw

Re: [PHP-DB] stuck on stupid...can't find the bloody error...

2004-04-25 Thread Rachel Rodriguez
> echo ""; > echo""; Try that first, and see if it fixes your issue. I'm shutting down for the day and unfortunately, I didn't have time to parse through the remainder of script. ~Rachel = ~Rachel __ Do you Yahoo!? Yahoo! Phot