[PHP-DB] Re: PHP/MySql - address book

2002-01-06 Thread George Nicolae
look at http://www.webmasterbase.com/article/228 -- Best regards, George Nicolae IT Manager ___ X-Playin - Professional Web Design www.x-playin.f2s.com "Sg" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi, >

[PHP-DB] Re: Probably an easy question - blank search fields (PHP & MySQL)

2002-01-06 Thread George Nicolae
if (empty($var)) { } else { } -- Best regards, George Nicolae IT Manager ___ X-Playin - Professional Web Design www.x-playin.f2s.com "Gary Smith" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hiya, I'm w

[PHP-DB] Re: hiding blank MySQL results?

2002-01-05 Thread George Nicolae
please give us some more code to help you. -- Best regards, George Nicolae IT Manager ___ X-Playin - Professional Web Design www.x-playin.f2s.com "Nathon Jones" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... >

[PHP-DB] Re: Redirecting to a new page

2002-01-04 Thread George Nicolae
if ($myrow[Admin] == "Y"){ > header ("Location:admin.php"); > }else{ > header ("Location:user.php"); > } -- Best regards, George Nicolae IT Manager ___ X-Playin - Professional Web Design www.x-playin.f2s.com "Matt Stewa

[PHP-DB] Re: Urgent!!!

2002-01-03 Thread George Nicolae
select substring_index(date_record,"-",1)+id as sum from test order by sum -- Best regards, George Nicolae IT Manager ___ X-Playin - Professional Web Design www.x-playin.f2s.com "Thomas "Omega" Henning" <[EMAIL PROTECTED]> wrote in me

[PHP-DB] Re: Urgent!!!

2002-01-03 Thread George Nicolae
ecord is a date column id is an integer column -- Best regards, George Nicolae IT Manager ___ X-Playin - Professional Web Design www.x-playin.f2s.com "Thomas "Omega" Henning" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAI

[PHP-DB] Re: Urgent!!!

2002-01-03 Thread George Nicolae
and who looks the query with "substr the date so i get only the year"? Type the exact query you make. -- Best regards, George Nicolae IT Manager ___ X-Playin - Professional Web Design www.x-playin.f2s.com "Thomas "Omega" Henning" <[EMAIL PR

[PHP-DB] Re: Urgent!!!

2002-01-02 Thread George Nicolae
you can't make this query because type mismatches. -- Best regards, George Nicolae IT Manager ___ X-Playin - Professional Web Design www.x-playin.f2s.com "Thomas "Omega" Henning" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]&quo

Re: [PHP-DB] odbc date

2001-12-31 Thread George Nicolae
date() use a timestamp. I receive a string. if I echo odbc_result($cursor,"date") it shows like "2001-11-21 00:00". Can it echo (without date() function because I don't receive a timestamp) "21 Nov 2001"? -- Best regards, George Nicolae IT Manager

Re: [PHP-DB] odbc date

2001-12-31 Thread George Nicolae
ery "select date from my_table" -- Best regards, George Nicolae IT Manager ___ X-Playin - Professional Web Design www.x-playin.f2s.com "Andrew Hill" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Geo

Re: [PHP-DB] odbc date

2001-12-31 Thread George Nicolae
i did it with date("F j, Y",strtotime(odbc_result($cur,"date"))). but i very curios about the query. it must looke like..? select date from my_table? -- Best regards, George Nicolae IT Manager ___ X-Playin - Professional Web Design www.x-playin.f2s.

[PHP-DB] Re: product selection from url ?

2001-12-30 Thread George Nicolae
"select * from your_database where pid=1234" -- Best regards, George Nicolae IT Manager ___ X-Playin - Professional Web Design www.x-playin.f2s.com "Dave Carrera" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]

[PHP-DB] odbc date

2001-12-30 Thread George Nicolae
for Win32(NT) and MSAcess 2000, whenever you retrieve a date column/field, php will automatically convert it to '/mm/dd hh:mm:ss' format regardless of the style of date you've denoted in Access how can I resolve this problem and print in a different format? -- Best regards,

[PHP-DB] Re: odbc insert

2001-12-29 Thread George Nicolae
it's OK. I did it. -- Best regards, George Nicolae IT Manager ___ X-Playin - Professional Web Design www.x-playin.f2s.com "George Nicolae" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > pls help me with syn

[PHP-DB] odbc insert

2001-12-29 Thread George Nicolae
pls help me with syntax for insert into mdb via odbc. -- Best regards, George Nicolae IT Manager ___ X-Playin - Professional Web Design www.x-playin.f2s.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

[PHP-DB] Re: php and accessconnection

2001-12-27 Thread George Nicolae
look at http://www.phpbuilder.com/columns/siddarth2228.php3 for a good tutorial. -- Best regards, George Nicolae IT Manager ___ X-Playin - Professional Web Design www.x-playin.f2s.com <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[E