Re: [PHP-DB] Re: delete message function

2011-06-14 Thread Simcha Younger
first query? Also, you should avoid extract, it litters your code with dead and untraceable variables. Use $array['msg_Passowrd'] instead. -- Simcha Younger simcha.youn...@gmail.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] jpgraph and mysql passing array

2011-03-24 Thread Simcha Younger
the php variables. img src=bandingGraph.php?$datax=$row[Distance]$datay=$row[MBusage]; // I think this is where I am having issues. try instead ?php echo 'img src=bandingGraph.php?datax='.$row[Distance].'datay='.$row[MBusage].''; ? -- Simcha Younger sim...@syounger.com -- PHP Database

Re: [PHP-DB] Re: Stuck in apostrophe hell

2010-08-04 Thread Simcha Younger
need double-quotes here, \%s\, parseNull($_POST['Company'])., '$_POST[Phone]', '$_POST[Email]' ), mysql_real_escape_string($_POST['Registrant'])); -- Simcha Younger sim...@syounger.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Trying to make site map

2010-01-03 Thread Simcha Younger
level. Any ideas how I can get this to work? In the end there will be 5 levels. Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Simcha Younger sim...@syounger.com -- PHP Database Mailing List (http://www.php.net

RE: [PHP-DB] Delicious style Tags table

2008-09-11 Thread Simcha Younger
' group by taggings.id You probably awnt a LEFT JOIN instead of a Simcha Younger -Original Message- From: Catharsis [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2008 1:41 PM To: php-db@lists.php.net Subject: [PHP-DB] Delicious style Tags table So I am having difficulty

RE: [PHP-DB] Delicious style Tags table

2008-09-11 Thread Simcha Younger
I did a little testing, and this should work better: Select... From... group by taggings.id HAVING GROUP_CONCAT('name') like 'soup' AND GROUP_CONCAT('name') like 'vegetarian' Simcha Younger -Original Message- From: Catharsis [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11

RE: [PHP-DB] Adding br's

2008-09-01 Thread Simcha
It is not clear if all four words are one string separated by line breaks, or if they are stored separately. If you have one long string, with linebreaks, use: $ anagram = preg_replace(/^(.)/mi, br/b$1/b, $ anagram); Simcha Younger p.s. I think you meant an acronym. -Original Message

RE: [PHP-DB] Random content from MySql DB

2008-08-26 Thread Simcha
If the past questions are 1,2,3,4: Select * from `questions` where id not in (1,2,3,4) order by RAND(); Simcha Younger -Original Message- From: A. Joseph [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 26, 2008 7:38 PM To: php-db@lists.php.net Subject: [PHP-DB] Random content from

[PHP-DB] RE: [PHP] If Column Exists

2008-08-13 Thread Simcha
You can try 'select `testcol` from `table`' and then check if you got a mysql_error(). -Original Message- From: Robin Vickery [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2008 10:33 AM To: php List Subject: Re: [PHP] If Column Exists 2008/8/12 VamVan [EMAIL PROTECTED]:

RE: [PHP-DB] Date Translation in MySQL

2008-08-05 Thread Simcha Younger
Select * FROM ... WHERE DAYOFWEEK(datecol)=7 -Original Message- From: Ben Miller [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2008 8:10 PM To: PHP. DB Mail List Subject: [PHP-DB] Date Translation in MySQL I'm looking for a quick and simple way to query a MySQL database by date,