hi, Can we reset the id auto increment in the mysql database using by phpMyadmin? let's say the
shoutbox . the id #number table.. somehow i deleted some rows.. and i wanted to re-order/reset the
id number acendingly in order rather than skip out.. thks ...

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...

Whenever I use 'delete from table where id = 4' from a table with several rows up to 10,
the 4th row is removed and the update simply shows the rest from 1 to 10 without 4. This is not what
I want. I want the table to now read 1 through 4 to 9 so that futher delete actions will be in that
sequence. I want to identify my row with the id (number). Can anybody help out here. Very urgent.
Serialmike....

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? ...

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...

Please help me. I'm building a group of database fro a program. the situation is like this:
'user' may have 1 or more class(es). 'class' itself may have 1 or more user in its
classroom. I'm bad at explaining... maybe like this: A program is made to write data of
classroom. Hikaru has a math class at Monday and statistic class at Tuesday. The math class itself
consists of about 50 students in a classroom. So, Hikaru (user ) may have one or more class at
time, math class (class) may have one or more students at time. So, basically I must mak...

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.....

Hello...I'm designing a website in PHP where ppl can submit their links for "cool sites".
Anyway, when somebody submit's a link to a website for example "http://www.google.com" it
creates an id such as "index.php?id=1134411593". I dont want the links to be converted into
id's. I want it to remain as "http://www.google.com". I have the following coding on
( echo " ). I'm a novice. Please Help!!!!
Thanks... Plus I also want to add the date on when the link was submitted. Please follow our foru...

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 am testing my website on my local machine. It is still in development stage and I am using
php/mysql. If there is a mysql connection error, I am checking for the connection variable and
displaying a proper error message. But even before it displays my error message, it displays an
error message on browser thrown by mysql (MySQL Connection Failed: Access denied for user). Can I
suppress this message and display only my message?...

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...

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)...

I have some problem about set permissions by automatic.. for example... I created txt file with
php... but when my file was added to server(trap17), it always set to 644 and i want to set it to
666 . Anybody help me... PLEASE /biggrin.gif' border='0' style='vertical-align:middle'
alt='biggrin.gif' /> ...