Hi all,
I am trying to dump an Access db query and form it into a comma delimited
file.
I get the query ok. I can get it into a table with odbc_result_all.
If I print the variable, it shows the first value from the first row...
Any hints on the path I should take?
Thanks,
D
--
PHP Database
It is not easy to design a SQL query that will repeat headers every 33 rows.
So this should be done in the PHP code.
Why not use a counter, that you increment at every mysql_fetch_array() and
test if !( $counter % 33 )
Side remarks: you could also define a CSS class for TH and use TH as
headers.
Hello
Working with jpGraph Gnatt Graph
Sample gnatt files shows data array as follows:
$data = array(
array(0,Concept,2002-9-1,2002-9-15,blue),
array(1,Creative,2002-9-15,2002-9-30,red),
array(2,Produce,2002-9-31,2002-10-10,green)):
Output $data looks like this:
0: 0
1: Concept
2: 2002-9-1
3:
[EMAIL PROTECTED] (John Thorne) writes:
$data[$cpt]= $row[0].,.$row[1].,.$row[2].,.$row[3].,.$row[4];
What you need is a two dimensional array. The code above concatenates
the $row elements into a string and puts this string into a one
dimensional array.
the 2D array $foo[3][5] can be seen as:
I want to transfer a large amount of data(at least 5000 records with 10
fields) from MSAccess to DB2 through PHP_ODBC.
When I run my script i get an error message No more Handles(see at the end
the exact message). I found this
message at hte information Center but it didn't help me much. Also i
Hmmm...still no takers on this one
I decided out of curiosity to start liberally adding free() calls
whenever I did a db-query(). Unfortunately it seems that the free()
call causes it to die. Not quite sure why, but it did. Most of the
calls that I use a query() for (as opposed to
Hey, this isn't totally a php question, but I would appreciate if anyone has
any advice for me.
I have a php script that accesses a folder, and displays all the photos
inside the folder. I want to use this script to display images that people
upload from the anonymous ftp account. I know that
Hi!
Normally one would read that folder with read() and echo all the files
makeing hrefs like this:
$dir = open('/home/username/public_ftp/incoming/');
while($file = $dir-read())
echo 'a href='.$file.''.$file.'/abr'.\n;
Don't forget to make sure, that the path is ok within the href...
-
In MySQL, I have noticed that you can't create a virtual table by using the
following syntax:
select * from (select * from table where agyID=1) where clnID=...
Is this correct?
Thanks for your time,
Philip
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Hello,
I don't know if this is the right list to send this question to. It appears that the
browser caches the result after a PHP page updates the database. I have to manually
reload it in order to see the updates. Does anyone know how to overcome this?
Thanks,
Philip
--
PHP Database
Hi,
Am using php to open a customer's msaccess file.
First time for everything. It's a very small database of less then 25
rows, and will always be this small.
Am needing to return all the rows to a web page using php at all times.
Very simplistic.
Am apparently set up correctly on the
Hi Philip Zee,
I don't know if this is the right list to send this question to. It appears
that the browser caches the result after a PHP page updates the database. I
Possible that your browser stored the content of the page as normal html-page.
Normaly CGI and dynamic webcontents are not
[EMAIL PROTECTED] (Philip Zee) writes:
I don't know if this is the right list to send this question to. It
appears that the browser caches the result after a PHP page updates
the database. I have to manually reload it in order to see the
updates. Does anyone know how to overcome this?
If you
Thanks for the reply
I do not under stand how to apply your example
$foo[$i][$j] = bar;
Graph example array trying to create thru sql:
$data = array(
array(0,Concept,2002-9-1,2002-9-15,blue),
array(1,Creative,2002-9-15,2002-9-30,red),
array(2,Produce,2002-9-31,2002-10-10,green)):
Output $data
[EMAIL PROTECTED] (John Thorne) writes:
[ snip ]
$data[$cpt]=
$rownu.,.\.$row[0].\.,\.$row[1].\,.\.$row[2].\;
This is a string, not an array.
Could you go a step farther in the $foo[$i][$j] please
$data[$cpt][0] = $rownu;
$data[$cpt][1] = $row[0];
$data[$cpt][2] = $row[1];
$data[$cpt][3]
G'day all,
I have a folder with an (Option-F) in the name which PHP processes as
Ä.
Is there some sort of encoding/unencoding which will handle this character
correctly? I've tried URLencoding and htmlspecialchars but I don't really
know what to search for in the docs.
cheers
kim
--
PHP
Matt --
...and then Matt said...
%
% I have a php script that accesses a folder, and displays all the photos
% inside the folder. I want to use this script to display images that people
% upload from the anonymous ftp account. I know that when they upload a photo,
% it goes into the:
%
%
$cpt=0; $rownu =1;
while($row = mysql_fetch_row($result))
{
$data[$cpt][0] = $rownu;
$data[$cpt][1] = $row[0];
$data[$cpt][2] = $row[1];
$data[$cpt][3] = $row[2];
$rownu++;
$cpt++;
This worked perfectly
Fredrik..
thank you
jrt
Fredrik De Vibe [EMAIL
$cnx = odbc_connect( 'DSN' , 'USER', 'PASS' );
if (!$cnx) {
?Could not connect to ODBC?
}
$cur= odbc_exec( $cnx, SELECT Vehicle.Vehicle_ID, Vehicle.Cust_ID FROM
Vehicle );
if (!$cur) {
Error_handler( Error in odbc_exec( no cursor returned ) , $cnx );
}
//
This may not be true in your case, but I remember another user on this list claiming a
similar thing, and his problem was actually code-related. He had his db update code
*AFTER* the results were displayed (ie. doing edit and save on same page).
Check your programming logic. Just a note to
On Sun, Feb 16, 2003 at 08:14:57AM -0800, David Chamberlin wrote:
David Elliott wrote:
try
?
echo date(d,$dbdate).br;
echo date(m,$dbdate).br;
echo date(y,$dbdate).br;
?
I thought date() took a timestamp, not a string. Here's what I do:
$timestamp = $dbdate;
echo date(d,$timestamp)
echo
21 matches
Mail list logo
