[PHP-DB] Splitting Arrays in Half

2004-12-09 Thread Jacob Hackamack
Hello all, I have the following code and here is my goal: I have an array and right now, as the code stands, I have one column of data on a page. I want it to have 2 colums of data on a page. I have tried this and it just returns blank so I am asking for some help. Thank you in advance and I

[PHP-DB] Insert db values into dropdown box error

2004-12-09 Thread Edward Dias
Hi, I would like insert into a dropdown box values from my mysql database column Using the sample below I'm getting this error (Parse error: parse error, unexpected) on this line (while($row=mysql_fetch_array($result)({ ) But I'm not able to identify the problem, Any help is greatly

RE: [PHP-DB] Mozilla inserts twice, IE does OK... ?

2004-12-09 Thread Steven \[Offstage\]
Hi all Note in the source that in the MySQL Insert query VALUES starts at a new line. I put a DELETE command right after the INSERT command, to temporary catch the double line. When I did that, I placed the VALUES...-part on the same line as the first part of the query and the double inserts

RE: [PHP-DB] Insert db values into dropdown box error

2004-12-09 Thread Norland, Martin
-Original Message- From: Edward Dias [mailto:[EMAIL PROTECTED] while($row=mysql_fetch_array($result)({ echo option value=\$row[project_number]\$row[project_number]/option\n; } You have a backwards parenthesis. Try: while($row=mysql_fetch_array($result)) { Cheers, - Martin

Re: [PHP-DB] Insert db values into dropdown box error

2004-12-09 Thread dpgirago
It looks like the parenthesis on the line with the 'while' loop is an opening parenthesis instead of a closing parenthesis. while($row=mysql_fetch_array($result)({ ^ dave

RE: [PHP-DB] Splitting Arrays in Half

2004-12-09 Thread Norland, Martin
*** Your entire set of code is commented out. Fix that first and play with it. /* begins a comment, that doesn't end until a */ /* $total_count++; Should be // $total_count++; Or /* $total_count++; */ The same goes for $display_count++; later in your code.

[PHP-DB] Correction: [PHP-DB] Splitting Arrays in Half

2004-12-09 Thread Jacob Hackamack
I was thinking. The way I have it now the code is commented out the parts that I thought would work and allow me to have two columns. I have commented them out because in the production environment it was returning nothing so I at least have to have it show SOMETHING! Thanks in advance.

RE: [PHP-DB] Mozilla inserts twice, IE does OK... ?

2004-12-09 Thread Steven \[Offstage\]
And now it double-inserts again. I was too quick with my previous mail :-) The quest continues... :-) Steven Hi all Note in the source that in the MySQL Insert query VALUES starts at a new line. I put a DELETE command right after the INSERT command, to temporary catch the double line.

[PHP-DB] sessions

2004-12-09 Thread Warren Mason
I am attempting to get information from a mysql database and then use this in a session. Is there a trick to using sessions? For example, can something like below be placed anywhere in a script? (I have the session_start(); at the very top of my page.) session_register( session_username );

[PHP-DB] versioning a database

2004-12-09 Thread Chris Wagner
hello. what i want to do is version a database. i am not sure if i am using the right word for this, but... you see, i am constantly modifying the format of various tables within my MySQL database, for use with my PHP app. It is difficult to keep track of places in the code that need to be

Re: [PHP-DB] sessions

2004-12-09 Thread Jochem Maas
try using the $_SESSION superglobal var (google is your friend if its new to you.) no need to register (still need to do session_start() though) just do... $_SESSION['MyValue'] = array( 'name' = $username, 'level' = $account_level ); ...or something like that. (also works for

Re: [PHP-DB] sessions

2004-12-09 Thread Warren Mason
Thanks to everyone that replied. All working great now thanks. Warren Jochem Maas [EMAIL PROTECTED] 10/12/2004 2:47:28 pm try using the $_SESSION superglobal var (google is your friend if its new to you.) no need to register (still need to do session_start() though) just do...