Advertisement

06.05.2008 at 01:19PM PDT, ID: 23461782
[x]
Attachment Details

PHP MySQL select statement multiple tables

Asked by pda4me in PHP and Databases, PHP Scripting Language, MySQL

I am using the following PHP code to select data from a table called resi.  Is it possible to also edito this code to search resi and another table called commercial?  If so, can someone update my snippet properly?Start Free Trial 
1:

$query_Recordset1 = sprintf("SELECT * FROM resi WHERE sAgentID = %s", GetSQLValueString($colname_Recordset1, "text"));
 
Keywords: PHP MySQL select statement multiple ta…
Title
1 PHP Script needed (Free or Commerci…
2 Backing up a MySQL Table with PHP
3 PHP Security
4 PHP form Submit
5 Trying to echo a calculation in MySQL
6 PHP MYSQL echo help
 
Loading Advertisement...
 
[+][-]06.05.2008 at 02:00PM PDT, ID: 21723948

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.05.2008 at 02:45PM PDT, ID: 21724317

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.05.2008 at 06:21PM PDT, ID: 21725502

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.06.2008 at 12:51AM PDT, ID: 21727009

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: PHP and Databases, PHP Scripting Language, MySQL
Sign Up Now!
Solution Provided By: hernst42
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628