Webmaster Forum / PHP / Database Access / April 2006

I have a problem with mysql query
I have a table  Teams  and field       'date'   (12-01-2006 format)
I want to see all records but date format I want  is  12/01   %d/%m
My query

Hi, all I was trying to add md5 encryption to all of my scripts that
needed username and password info entered into the db well every thing
goes smoothly until I try and login.
I encrypt it when it goes in and before I check it after I sent the

need help
My english is not good so ill be short.
This is my database in mysql
create table customers

Hi  everyone
I am trying to send a e-mail using the mail() function.
Now i try to send more than one data from mysql database so i must use
example

i can INSERT and UPDATE but DELETE is not working
$sql = "DELETE FROM table WHERE ID='$ID'";
$sql_result = mysql_query($sql,$connection) or die ("Couldn't execute Delete
of row $ID.");

i am trying to update a group of values in 1 table all at once.
my sql string is
$sql = "UPDATE job_adverts (Posted_ID, Date_Posted, Job_Title, Job_Code,
Job_Location, Job_Salary, Job_Description, Company_image, Contact_Name,

MySQL version : 5.0.18
I have the following query:
select p.products_id products p where p.products_id in (select
c.anonymous_id from c1 c  order by c.satisfaction DESC LIMIT 5);

i have some data which i can read ok but i need to display by date posted.
Problem is the date is stored in a field as text DD/MM/YY
using ORDER BY date_posted ASC does not give desired effect as it seems to
use only the DD

I need to sort my job postings from today to the past, but my date sort
basically sorts dates from January to December. How do I get the sort to
start from the today's date back
SELECT jobs.id, jobs.jobtitle, jobs.companyname, jobs.zipcodeId,

I was instaling a small web service for a friend (on his computer, only
remote ssh access). I managed to set up apache2 with php support and
mysql running as well (we had few problems with that, since slackware
instalator did not changed permissions.. but it's fine now)

I'm looking for a very simple open source and free shopping cart that would
run on a PHP, MySQL, Apache, windows XP combo
The features already built-in should be :
-login system for clients (with a sessonid to allow them go from one page to

I need to do croning in PHP to generate a CDR (Call Details Record
file daily from the mysql database.
The CDR file has to be named in a certain sequence such a
xx00000xxx200604080850.cdr. A new file is written every day

Trying to find a MySQL database of business categories for an upcoming PHP
project.
Example: Business > Accountants, Business > Bankers, etc...
Thanks

Hi. I am attempting to get msql3 installed with php. Using php version
php5.1-200604070430 and msql-3.7. I am getting the following error on
compile.
/usr/lib/gcc/x86_64-pc-linux-gnu/3.4.6/../../../../x86_64-pc-linux-gnu/bin/ld:

How can I stop a function in PHP?
When comparing data I want to stop the function on a hit.
Function compare($data)          {
For ($n=1; $n<=10000; $n++)     {