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
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
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+
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
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.
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
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
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
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
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
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
11 matches
Mail list logo