RE: [PHP-DB] Compile Error

2006-02-21 Thread Bastien Koert
No problems compiling, but there are problems with the code i get: MySQL Database Server Information Warning: mysqli_connect() [function.mysqli-connect]: Access denied for user 'user'@'localhost' (using password: YES) in C:\Apache2\www\xhtml.php on line 11 MySQL client version: 4.1.7 Warn

RE: [PHP-DB] Compile Error

2006-02-21 Thread Bastien Koert
My Bad...works fine MySQL Database Server Information MySQL client version: 4.1.7 MySQL connection: localhost via TCP/IP MySQL protocol version: 10 MySQL server version: 4.1.7 forgot to change the logon details bastien From: Benjamin Stambaugh <[EMAIL PROTECTED]> To: php-db@lists.php.net

[PHP-DB] Re: my_sqli documentation...

2006-02-21 Thread Alex Boese
I have noticed a real gap in my_sqli docs out there. Specifically, it would be nice to know with prepared statements ($stmt), what methods/properties they have specifically available and which are only available to the ($result) result object of a query. Also, which if any are not available a

[PHP-DB] Compile Error FIXED

2006-02-21 Thread Benjamin Stambaugh
I fixed my own problem. It was my Apache web server that was not working correctly. Quoting Benjamin Stambaugh <[EMAIL PROTECTED]>: Hi. I have been having issues with PHP compiling. It was workin fine until a day ago and now every time I try to access a page with any kinda of PHP script I c

Re: [PHP-DB] Data split: web & local machine

2006-02-21 Thread Martin Alsinet
There was a thread a while ago about credit cards Storing Credit Cards, Passwords, Securely, two-way encryption http://beeblex.com/lists/index.php/php.db/40981?s=l:php.db The part that really gives me the willys is: > > The procedure I initially thought of, was generating a file on the web > side

[PHP-DB] Creating checkbox list.

2006-02-21 Thread Jeff Broomall
Good evening. I'm sure this is something easy so I'm hoping you can simply steer me to a good source. I simply need to create a Checkbox list using data from my "groups" table. I have a table with two fields: 1) groups_id 2) groups_name The data contained is simple: groups_id groups_name

RE: [PHP-DB] Creating checkbox list.

2006-02-21 Thread Bastien Koert
I'll skip the sql (figuring you'll have that covered) while($rows = mysql_fetch_array($result)) { $id = $rows['group_id'] ; $name = $rows['group_name']; echo "value=\"$id\">$name >"; } Bastien From: "Jeff Broomall" <[EMAIL PROTECTED]> To: Subject: [PHP-DB] Creating checkbox list.

Re: [PHP-DB] Creating checkbox list.

2006-02-21 Thread MIGUEL ANTONIO GUIRAO AGUILAR
OK, let's see: First, do the connection to your DB $query= "select * from groups"; // get the data from your grous table $ri=mysql_query($query, $li); // execute the query agains your table while ($data=mysql_fetch_row($ri)) { // get the row in turn, $data is the array that holds your group data

Re: [PHP-DB] Creating checkbox list.

2006-02-21 Thread Luis Morales
Hi, first you need connect to the database y attach on this example a litle extension class of Pear DB class. I suppose that your case use mysql database. this is an example: db_dbArray($DB, $q)){ for($i=0;$i_db['data']);$i+

[PHP-DB] Generate Report

2006-02-21 Thread Jeff Broomall
I thank those who promptly responded to my first inquiry on the list. This second request is, I assume, a tad more challanging. I need a "Generate Report" function that'll allow the user to select one or more "groups" and what columns he would like to view. For instance, Generate Report

Re: [PHP-DB] Generate Report

2006-02-21 Thread MIGUEL ANTONIO GUIRAO AGUILAR
It seems that you need to get your nose into your books!! More about SQL statements!! > I'm assuming I'll need to create an array for both "sel_group" and > "sel_cols" and then, I believe it's "implode" them into string > values??? Am > I thinking correctly??? NO, YOU ONLY NEED TO WALK THRU Y