Webmaster Forum / PHP / Database Access / March 2006

This one really has me stumped.
I need to add or update a mysql table with a string that includes double
quotes. I use the addslashes() function to set the necessary escapes. This
works with INSERT. However, with UPDATE the string is truncated at the first

I have a question about improving page rendering speed.
For instance, according to mysql the following query takes a mere 0.28
secs:
SELECT * FROM table1

   I have an application which needs the ability for a user to upload an
image from their hard drive (maximum 2mb)
   This image needs to have a unique reference i.e (name of user) connected
to it from a text input box.

Hi There, not sure if this can be done with SQL or if there is an SQL
crossover
I have two tables:
Table "record":

We are hiring a PHP developer!
The site must contain the following:
- database
- administrator panel (implementing multiple employee logins /

I have the following query   :
CREATE TABLE IF NOT EXISTS `pm_tusers` (
 `id` INTEGER NOT NULL AUTO_INCREMENT,
 PRIMARY KEY  (`id`)

I am currently making a dating website.
I want to have some information on how to structure the database and
the php files so that I can achieve speed and efficiency.
Can some one please give me suggestions and point me to references

Hi there, How (if) can i store the link from a mysql connect in a session
variable
something like
$_SESSION['db_link']=mysql_connect ( $server, $username, $password );

A newbie to php and mySql so please bear with me.
I have imported some data into a table but the first field has a leading "R
" which I need to trim off all 4,000 records.
Typically the field content is "R ERR3340" and I need to modify this value

I am trying to write a small app in php to make the 'COMMENT' statement
a bit more friendly, so we might do more documentation. My problem is a
set of error statements which have nothing to do with what I'm doing.
For instance when I try to run the trigger list with the code ...

I'm trying to build a Thesaurus. In my thesaurus i've created the
following tables: terms, btnt (broader terms/narrower terms), rt
(related terms)
The structures of the tables are like this:

Hello every one,
I need your help because I have no idea how to do this...
how can I get the veg_id into the table veg_type according to the vegetable
name

Can anyone tell me how i can prevent that users can see my connection string
to mysql database?
Using my browser i could easely use the function:  view source.....showing
the html/php code.

I am trying to insert info if a checkbox is selected.  The checkboxes
are created from this code (pulled from mysql):
##########
$ministry_info_query =  "SELECT * FROM ministries WHERE inactive = 0

I am not a PHP expert, and I turn to you all for some advice.
I would like to be able to provide access to a database through a
simple web portal.  The system I have in mind would allow another
system to pass an SQL query to a URL in the form: