[PHP-DB] echo delay...

Hi fellow php late night peoples Thanks for everyone's help the last couple of days... I have learned so much. The best way to learn this stuff...is simple trial and error... and thanks for good old Ggle! My problem tonight is very simple. I just don't know what command I want to

[PHP-DB] IF statement in WHILE statement

Hello Everyone, Got another simple problem here I am trying to do a if statement inside a while (mysql_fetch_array) Here is my code: if ($link = mysql_tech_array($links)) { do { if ($_GET['page'] = $link[file]) { $status = 'reg_button.php'; } else { $status = 'push_button.php'; }

Re: [PHP-DB] IF statement in WHILE statement

Thanks Chris... added the extra = and its working fine... Have a nice day everyone Matt - Original Message - From: Chris [EMAIL PROTECTED] To: Matthew Ferry [EMAIL PROTECTED] Cc: php-db@lists.php.net Sent: Tuesday, February 13, 2007 11:53 PM Subject: Re: [PHP-DB] IF statement

[PHP-DB] SQL Query - Using variable from another SQL Query

Hello Everyone Got a simple / stupid question. Worked on this all night. I'm over looking something very basic here. The query event_time brings back the calendar id for each event that is pending in the future. ie 12, 13, 14, 26 (There could be 100 of them out there) The second query

Re: [PHP-DB] SQL Query - Using variable from another SQL Query

; } while ($event = mysql_fetch_array($events)); } else { echo No Public Events Are Currently Scheduled...; } ? - Original Message - From: Matthew Ferry [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Monday, February 12, 2007 11:14 AM Subject: [PHP-DB] SQL Query - Using variable from

[PHP-DB] 2 queries -- 1 array

Hello, I need to query two different tables and create one BIG array. I can query both tables, but can't find a way to combine the results in one array. The problem comes in with the second table. It has a weird layout. The second table only has four fields. They are: contact_id,

Re: [PHP-DB] 2 queries -- 1 array

of the first table Thanks... Matt - Original Message - From: Natalie Leotta To: Matthew Ferry Sent: Friday, January 12, 2007 3:41 PM Subject: Re: [PHP-DB] 2 queries -- 1 array I think this will help, but I'm not sure I understood your question correctly. http

Re: [PHP-DB] 2 queries -- 1 array

yeah..that is what i'm trying to do, but I need to query WHERE contact_name='Supplier' and bring back the value for contact_value query WHERE contact_name='RANO' and bring back the value for contact_value query WHERE contact_name='Dynamic' and bring back the value

Re: [PHP-DB] 2 queries -- 1 array

query1 = SELECT * FROM egw_addressbook query2 = SELECT contact_id, contact_value FROM egw_addressbook_extra WHERE contact_name='Supplier' query3 = SELECT contact_id, contact_value FROM egw_addressbook_extra WHERE contact_name='RANO' query4 = SELECT contact_id, contact_value FROM

[PHP-DB] Filter array results... no copies

Hello everyone I'm back working on the website again... I'm having lots of fun. I have a sql query that looks at one field in a database. (result2 query) Then i have mysql_fetch_array statement. I then use this array to print links on the page. Works fine except I don't want duplicate links.