In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
Hi there,
The problem is the data is already in the DB, it was mass-added with the '
already there, what I need is a way to retrieve the ' that is already in the
DB.
Thanks
Chris
yes, by adding stripslashes it will somewhat
Hi,
I am using PHP 4.3.1, Apache 2.0.46 and MySQL 4.0.12 on Windows 2000
Processional Edition.
All the code are working fine, with only one exception. When I shut
down the database, the PHP script will continue running normally until
it reaches the part where information is retrieved from the
C'mon, think about it.
Connect to the database at the top of your page - if you can't connect
either error out and die, or branch to alternate output.
As far as lack of error reporting is concerned, check and see what level of
error reporting is set on the server; the manual has a helpful
C'mon, think about it.
Right on, Miles.
Hanxue,
One other thing to consider is if you're using the @ in front of your mysql
function calls in PHP (e.g. @mysql_connect()). Especially if you're using
the @ without and additional error checking with things like:
if (!$dbconnect) {
die
Hi Guys,
I have the following query which unfortunately has to grab all records
in a table (well over 3000) to display in a multiple select box.
Code:
?php
$manufQuery = db_query(SELECT manufacturer FROM
kcs_threads);
while ($manufResults =
You've got three queries, two of which are in while loops. If you're calling up
3000 records, you may have as many as 3000 DB queries, possibly more. That's
why things take forever.
Restructure your code, placing the queries outside the loops. Then use
mysql_fetch_array() and loop through the
