Webmaster Forum / PHP / Database Access / February 2006

  On my rented space I have only one database.  I have a few users at my  
site
and any mysql tables I made for them have their initials as a prefix    
i.e.

   Eventhough I've never hired out to anyone for anything that I know how
to do, I still like knowing what the skills I have are worth in the open
market. I'm not a database anything yet, barely a newbie, but I'd still like
to know what knowing this database stuff is worth. So, ...

im trying to write a page that can display a list of the databases from
mysql. i cant seem to find any commands for it other than executing "SHOW
DATABASES" as an SQL command. what am i doing wrong?

I'm running a query to return the contents of a MySQL table. I need to
be able to use the returned data more than once in my page so instead of
going through each row one by one using mysql_fetch_row() is it possible
to store the result set in a dataset or 2-d table? This way I ...

Hi all.  I've noticed people encasing their table and column names within
quotes.  Whats up with that? my db seems to be working ok so far without
them, so what are they for? Should I be doing the same?

i've got two tables :
one for categories of recipes :
---
 id_categories  categories_cat  categories_subcat

Alright I've been at this for a few hours and I'm not totally
frustrated, just wanting to make sure that there's not some obvious
solution here that I'm missing.
I have an album review site and I'd like for my visitors to be able to

I  have a script that gets the time that someone submits the form.  The
problem is my web host is on the west coast and I am on the east coast and
the time difference is 3 hours, so my script displays the time 3 hours
early.  I would appreciate any help or tips.  Here is what I ...

I have a content management page where I can place rich text.
On the confirmation page I display the rich text the user has inputted.
However, I am noticing that when images are included in teh rich text,
the confirmation page is not displaying it. When looking at the souce

I installed a script that is suppose to accept paypal, however on trying to
test a payment, I get this error msg:
Error
Database access error

I've got PHP running on IIS in XP Pro on a local machine at Port 8080
and the MySQL server on the same machine at Port 3306. My SQL server
has a Server host  name of localhost and a user name of root. I don't
use a password. Does anyone know whether it will, or should, be

I'm trying to write a PHP function that will go out to several sites
to grab data using the CURL function. The results are then reformatted
and displayed to the visitor.
The problem is that I need to go out to 5 or more sites and each one

I've got some lexicon-like application which stores data in 2 tables:
lexicon( id, description ) and keywords(lexicon_id, keyword)
This is flexible solution because there may be many keywords
for one description. My problem is how to make ONE query, that

Our hosting company's server went down a few days ago. After they fixed
it, our PHP Page and Database are not interfacing. They are not
believing me that I have done nothing on my end in several months with
uploading new files or doing anything with the database, insisting I

I have created a username  giving GRANT ALL ON *.* TO privileges...
I also did FLUSH PRIVILEGES, but this doesn't seem to change anything
either...
I have a wordpress blog on another ip that I am trying to install-  it