I am not new to programming. I want to create a form to add some values into my tables, the code
are all working. But I am not sure what is the URL to connect to my site's database. All along,
I have been testing through MAMP, which provides a local copy of mySQL. Can anyone lend me a hand?
My site's URL is http://limetouch.com/ ...

A search engine is provided to facilitate the user with undemanding and clear-cut search options.
The search facility includes simple search, search by title, search by word/phrase, ect… Thus, the
user is at a safe distance from the risk of selecting files/folders ambiguously. In addition, a
history of recent searches can be preserved for future perusal. Now
day’s visitors have a large option for his needs on internet and so visitors are not vesting their
time by following the dead links on your site. So a search engine is essential for your...

Hi all. I am trying to make a list out of 2 list. The first list is a complete list of users id
from users table (List A) The Second list is of users id from another table (List /cool.gif"
style="vertical-align:middle" emoid="B)" border="0" alt="cool.gif" /> I want to subtrack the user
ids in List B from List A and make List C. Thanks in advance for any help /smile.gif"
style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> Update: I looked up a old
sql book i had and found some query examples. I tried the EXCEPT statement in mysql but it dont wor...

hi there, im working on a performance request system, and i have three tables that im working with
right now. the performances table holds the info about the performance (date, times, status, etc.),
and has two columns, org_type and org_id, which both hold an int value to tell me where the
organization info is. there are two org types which have respective tables, because we collect
different information based on the type of org that is registering. is there any way to select info
from all three tables (dynamically selecting between the two org tables based on org_type,...

Please Help Me with this site's error http://gatewaybiz.x10hosting.com/surf/ ...

Can database column names start with a number or must they start with a letter like php vars? Like
my_table.1fieldname ? Does this vary from db system to db system? Is it considered good/bad form? ...

Hey all. Now i have a DB, an SQL DB, and i need to auto prune the data there to delete rows lder
than a certain time, lets say 2 months for now, the question is how do i do this? The obvious thing
is just to add a field which is the numerical representation of the month when the data is entered
and every time the DB is accessed it will check this number against the current month,in a numerical
format, and if the difference is two or greater that row is deleted, so if the month is January, it
would be O1 and if the current month is march then it would be O3 and the diff...

hi all , i have one big problem i need to know , how i can read xml file and then save strings in
xml in database for example its my xml CODE <?xml version="1.0"?>
<numbers> <arash>1</arash> <kiarash>2</kiarash>
</numbers> i want my soruce read this xml file and then save string into arash field in
mysql database for example in this source arash string is " 1" and kiarash string is "2" my fields
in mysql are standard and we have 2 field with names "arash" and "kiarash" please help me , if yo...

Hi all i want write backup system like Phpmyadmin export in single file , my question is what is
backup query ? i must write manul query for backup for example loop query to get string form
database and write into one file or php have backup query ? thanks /wink.gif"
style="vertical-align:middle" emoid=";)" border="0" alt="wink.gif" /> ...

I need help with a couple of things. First, I need to know how to retrieve information from a mysql
database and edit it then re add it to the database. I also would like to know how to easily delete
a mysql row. And I want this done without going to phpMyAdmin. Thanks for the help!...

I need help importing a .csv contents into a Mysql database. I have this. But its not working.
CODE <?php connection = mysql_connect("******", "**********",
"********") or die ("Unable to connect to server"); $db =
mysql_select_db("b9_259782_CC", $connection) or die ("Unable to select
database"); fopen ('csvranks.csv', 'r');
mysql_query("INSERT INTO test_table (id, name, guild, level, exp) ?> What
am I doing wrong? The mys...

Hi everyone!
I have a problem: when I create a table in MySQL,
I'm asked to fill up some information about each colum.

for example:
| Name | Type | Value | 2nd Value | Attib...

I got a solution using CREATE TEMPORARY TABLE to select MAX things out of a table in reference to a
Category. Now i want to know that is this CREATE TEMPORARY TABLE available after MySQL 3.23 Server
intensive. I checked it out on the MySQL Administrator software that monitors your MySQL Software
and the Load was infact less. But do all the hosts support this. Trap17 does but then too, do hosts
keep this on or no. I need this for my script. ...

Hi all i write this code i want when you see download.php (this code) my file goes for download for
user sorry my english is not very good its a file database project for my university but when i
browse this code my soruce file (.zip) echo in my page and dont goes for download my next querstion
about safe mode i saw (php.net and zend) when safemode is on file databaseing and header() is not
working . is it true ? if is it true i save my file at hosting and no (database) i want write
standard script . plz help me thanks more and more CODE include("config.php&...

Can anyone show me example code of how to install a database table instead of me having to upload an
file with it in, so i can do it from a php page? Thanks in advance ;-)...

I have a database, and need to know how to show the numbers of entries. So, if there are 10 entries
in the selected database table, it will show the number 10 . I'm pretty sure this should be
easy, but I don't know how to do it. Can someone tell me? /smile.gif"
style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" />...

Is there any way to make such database where I can write like name and passwords.. Then make an
login box, and when somebody trys to acces the login he needs to write the name and password.. Then
it is verifyed if is there such name and password and if it is then acces the page.. I think there
is posible something like that with MySQL (db).. but can anybody say me a script or way to make
something like that? Alredy thanks.....

i'd like to make an automated database backup as following: 1- i would like to optimize my
databse's tables. 2- I would like to remove any existing backup tarfile. 3- I dump the database
to a /tmp file. 4- I tar the database dump and then delete it. i wrote the following shell: CODE
#!/bin/sh rm -rf /tmp/mybackup.sql.tgz mysqldump -uroot -pmypass --opt mybackup >
/tmp/mybackup.sql.backup cd /tmp/ tar -zcvf mybackup.sql.tgz mybackup.sql.backup rm -rf
/tmp/mybackup.sql.backup ...

I'm planning on a site redesign, and I'm going to add some very basic php includes in there,
because I've managed to figure out how to do them. I wanted to use them to do includes of my
navigation, so I'd only have to update in one place when new links are added, as opposed to
having to update several pages all at once. I'm not sure what else php can be used for, and I
did a search on it, and it pretty much all said includes and databases. Well, databases, I
don't know how to make, and I was wondering if it's really worth my time to figure i...

hello again guys!, i was wondering if there is a way to get the table names from my database
using php. Well what i want to do is to get the name of the tables returned as an array or something
similar... thanx in advance...

Hi PHP geeks, Do you know if php has Database extraction layer? like Java has. Which is used for
development of database layer, so it become easy to change the database if you wish to without
modifying so much code underneath.... Any ideas is welcome. I am sure there should be something
which is being used and reliable and mature. I am new to PHP so want to use it if it is there. Good
to know from experienced developer about there developing experience. Thanks in advance....

I have just made a script that deletes a row in a mysql database using an image as a button.
However it will only work in FireFox and not in IE. Can any one see away around this and help me
root out the problem. This is the script in short: PHP Code: CODE $query_products =
"SELECT * FROM manufacturer ORDER BY name ASC";
include('external_files/pagination.php');    // If the form was submitted, delete
the items selected from the database
if(isset($_POST['delete'])){  $query = 'DELETE FRO...

Okay, after a week, I have successfully created a personal web blog. I first created it using a flat
text file, I but realized that it was just too limited like that. So, I redid it in a
database-compatible manner. NOTES: CODE - This blog does not support comments yet. If you
want, you can build  on this script by creating a comment system as well. I may also    update it
with a comment system in the future. - You should have an average to intermediate knowledge of
MySQL    commands and database manipulation in general, especially if you    want to add a ...

I am having trouble formatting my table to display the results of a mySQL query the way I want.
Here is the part of my code: CODE $result = mysql_query("SELECT * FROM uploads
WHERE Category='Drama'") or die(mysql_error()); ?> <table
cellspacing="2" cellpadding="2"> <tr> <th>Title</th>
<th>Author</th> <th>File</th></tr> <?php // keeps
getting the next row until there are no more to get while($row = mysql_fetch_array...

I'm making a forum and I've had several problems tonight which I've come here to ask
then found the answer to myself, but this one is stumping me. Whenever it goes to write the post to
the database, it saves the poster, and the time, but the part where the message would go is empty.
Here's the code, with comments about what it's supposed to do (what I wanted it to do and
thought it did): CODE $imsg = stripslashes($_POST['msg']);
//Get message if(strlen($imsg) > 5 && strlen($imsg)...

I have a simple database with a php form thats inserts the info into the database, and another file
that extracts the info to display the info on another page.... Now my question is ......how do i
add the EDIT button to edit the database??? here is my database CODE CREATE TABLE `businesses`
(  `id` int(10) NOT NULL auto_increment,  `business` varchar(255) NOT NULL
default '',  `description` text NOT NULL,  `emailaddress` varchar(255) NOT NULL
default '',  `website` varchar(255) NOT NULL default '', ...

Okay, this is a simple script that lets your visitors enter in messages via a chatbox/guestbook. You
can use this how you like. Adjust it if need be. It's very simple, so there is much room for
improvement. Enjoy! CODE echo "<form action='chatbox.php'
method='get'>"; echo "Name: <input type='text'
name='visName' size=15><br>"; echo "Message: <input
type='text' name='message' size = 15><br>"; echo "<input
type='submit' value...

I have a chat PHP script, that I need a little help with. I'm wanting to use PHP/MySQL so that
it will show the most recent message first. What it's doing, is showing the oldest message
first, and newest message last. Is there something I can do to reverse the order of the messages?
Thanks. (I know...I've had to ask for PHP help often, but I can't quite get a PHP book
right now...sorry)...