RE: [PHP-DB] Fixed Quote Marks in Inputs

2002-01-05 Thread Boaz Yahav
I just read your thread and I have to say that I was intrigued both by the subject (which is interesting) and by the different views you show. I just have one question for Jonathan : If you store the ' and " as ' and " what do you do if you need to show the data later on in a non HTML format (te

[PHP-DB] hiding blank MySQL results?

2002-01-05 Thread Nathon Jones
Hi. I have a PHP page calling a set of results from a MySQL database. They appear in the following format on the results page: Title Description Link Problem I'm having. When a db record has an empty field (for example, no description), the results page leaves a gap where the description shou

[PHP-DB] hiding blank MySQL results?

2002-01-05 Thread Nathon Jones
Hi. I have a PHP page calling a set of results from a MySQL database. They appear in the following format on the results page: Title Description Link Problem I'm having. When a db record has an empty field (for example, no description), the results page leaves a gap where the description shou

[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]... > Hi. > > I have a PHP page calli

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

2002-01-05 Thread Shooter
i would suggest in your while you do someting like this while($myrow=MySQL_fetch_array($result)) { $time=$myrow["time"]; if ($time =="") {$time ="Sorry No Result"; } echo "$time"; if u get my drift ? ? Nei;l - Original Message - From: Nathon Jones <[EMAIL PROTECTED]> To: <[EMAIL PROT

Re: [PHP-DB] Re: Array not supported for strings???

2002-01-05 Thread Jason Wong
On Saturday 05 January 2002 04:24, Andy wrote: > Here is the full code: > > ### > # Get the name of the country: > > if (isset($country_id)){ //only if there are results > >for($i=0; $i< count($country_id); $i++){ > $stmt= " > SEL

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

2002-01-05 Thread Neil Thomson
ok i get your point. how about "; } if ($discription !=""){ $discription1=$discription""; } if ($link !=""){ $link1=$link""; } echo "$title1 $discription1 $link1"; ?> the != means if does not equal. so basically that should i think do. if the title does not equal nothing then add a to the end

[PHP-DB] Subscription

2002-01-05 Thread amka kama
Confirm my subscription Do You Yahoo!? Send a newsletter, share photos & files, conduct polls, organize chat events. Visit http://in.groups.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL P

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

2002-01-05 Thread Raquel Rice
On Sat, 5 Jan 2002 01:12:21 - Nathon Jones "Nathon Jones" <[EMAIL PROTECTED]> wrote: > Hi. > > I have a PHP page calling a set of results from a MySQL database. > They > appear in the following format on the results page: > > Title > Description > Link > > Problem I'm having. When a db r

[PHP-DB] dates in db

2002-01-05 Thread Adam Jackson
i have a date in my mysql database in the format of 20011201 how do I output that to show for example 01 December 2001 or something similar? Cheers Adam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTE

Re: [PHP-DB] dates in db

2002-01-05 Thread Stephen Abshire
Try something like: date_format(news_date, '%d %M %Y @ %H:%I:%S') Go to http://www.mysql.com/doc/D/a/Date_and_time_functions.html and look for date_format to determine what parameters to use in order to format the date as you want it. Note that this method will actually format the date retur

[PHP-DB] Building a user preference site

2002-01-05 Thread Danny Kelly
Hello, I am trying to figure out how to setup a user preference system. When the user successfully logs in they will go to a page that will display their preferences. I have a Mysql database that contains all the user info. How do I START developing a site like this. Thanks, Dan -- PHP Database

Re: [PHP-DB] Building a user preference site

2002-01-05 Thread Neil Thomson
use either sessions or cookies. ur choice. look @ the manual on both. Neil - Original Message - From: Danny Kelly <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, January 05, 2002 6:42 PM Subject: [PHP-DB] Building a user preference site > Hello, > I am trying to figure out

Re: [PHP-DB] Building a user preference site

2002-01-05 Thread Rich Buggy
> I am trying to figure out how to setup a user preference system. When the > user successfully > logs in they will go to a page that will display their preferences. I have a > Mysql database that contains all the user info. How do I START developing a > site like this. Thanks, Dan What I find