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 #039; and #034; what do you do if you need to show the data later on in a non HTML

[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

[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 calling a

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= SELECT country

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

2002-01-05 Thread Neil Thomson
ok i get your point. how about ? while($myrow=MySQL_fetch_array($result)) { $title=$myrow[title]; $discription=$myrow[discription]; $link=$myrow[link]; if ($title !=){ $title1=$titlebr; } if ($discription !=){ $discription1=$discriptionbr; } if ($link !=){ $link1=$linkbr; } echo $title1

[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

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 record has an

[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

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

[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

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 how

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