Thx Jakob,
appreciate the help
Cheers Joe :)
Lerp <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi there. Got a bit of a snag. I'm migrating an ASP app to PHP with a
> mssql7.0 backend. The snag is this, I have a 'starttime' field in my db
> using the 'date
Jas
color=\"33\">\n";
}
?>
The is in the loop. Place it outside & you'll be OK.
Miles Thompson
At 01:35 AM 2/15/2002 -0700, jas wrote:
>I am having a little problem formating data retrieved from a database into
>table cells... So far after connecting and querying the database table the
>
Further, I recommend replacing your echos with the following:
echo "Type Of Car: "".
$myrow['car_type']."\n";
echo "Model Of Car: ".
$myrow['car_model']."\n";
echo "Year Of Car: ".
$myrow['car_year']."\n";
echo "Price Of Car: $".
$myrow['car_price'."\n";
echo "VIN Of Car: ".
$myrow['car_vin']
Your is inside your loop. So it is executed once to terminate the
table. After that, the browser just sees the rest as straight text.
-Original Message-
From: jas [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 2:35 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] formating w/ tab
I am having a little problem formating data retrieved from a database into
table cells... So far after connecting and querying the database table the
data is put into table cells, however after the first entry is displayed in
the table all the other entries loose the formating, HELP?
Current Inven
Hello...
Try this...
$pat = array("\", "@", "*", "&", "%");
$with = (_) \\What ever you want...
$car_year = str_replace ($pat, $with, stripslashes($car_year));
echo $car_year;
This would work with ONE VARIABLE...
I suppose maybe you could make the
Variables($car_type,$car_mod
Sorry Rick, I should've been more clear with my problem, but now it's not a
problem anymore. I got it to work perfectly. The two times were the original
starttime and then the endtime would be time() (the time now). My problem
was with calculating the hours between the two, I got it a few moments
I have a script that prevents invalid characters from being passed from a
html form to a mysql database using php and I am wondering if there is a way
to condense it so instead of declaring the ereg_replace for each field in
the html form, to simply use one function to remove invalid characters an
Peter,
I totally appreciate the extra effort on this one!
Just so you know, the results come back as two records
per client. Like this:
| ClientName | Status | Count |
| Steve | 2 | 25|
| Steve | 3 | 83|
| Gary | 2 | 12|
| Gary | 3 | 33|
Are you saying you got two different return values with the exact same input
values for $hour, $minute, $second, $month, $day, $year??
-Original Message-
From: Lerp [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 8:46 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Time Difference
Hi again. I have a date field in my mssql 7.0 db format : 2/14/2002
12:21:28 PM . I would like to know how to calculate the difference in
seconds between 2 such timestamps.
$starttime = mktime($hour, $minute, $second, $month, $day, $year); returns
:1013776613
endtime = mktime($hour, $minute, $s
Hi again.
When I try to optimize a data table, I get this error:
Optimize error: The handler for the table doesn't support check/repair.
Is there something in mysql's settings that I need to change?
--
Faye Keesic
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: htt
How are you fetching the data?
Do you have indexes on the key fields used in queries?
Are you doing the work in SQL or sorting /rearranging a lot of arrays?
There are many possibilities for slowness, but you have to tell us what
you're doing.
Regards - Miles Thompson
At 11:53 AM 2/15/2002 +010
Hi everyone.
I have a big problem with my billing software.
I have coded it using PHP and MySQL as the database.
Everything seems ok, but when I do accesses to my DB, it is very slow !
For example, I am able to download the csv file for a specified account
(that is not the problem).
If I downl
14 matches
Mail list logo
