Board index   FAQ   Search  
Register  Login
Board index php forum :: php coding PHP coding => General

query

Ask about general coding issues or problems here.

Moderators: macek, egami, gesf

query

Postby greasypalm » Wed May 07, 2003 5:35 am

Is it possible to search a database table for info and then take that info and then query a table and then display the results?

if so could you please show me how?
greasypalm
New php-forum User
New php-forum User
 
Posts: 6
Joined: Tue May 06, 2003 11:33 am

Postby Skeletor » Wed May 07, 2003 6:21 am

You may be able to use something like the following.
1) query and retrieve the value to be tested for in the 2nd query.
2) if that value is not empty, then query against the database for results matching the value.

*** EXAMPLE ***
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = "SELECT * FROM first_table WHERE somefield='somevalue'";
$result = mysql_query($query) or die(mysql_error());
mysql_close();

$row = mysql_fetch_row($result)
if(!empty($row['somefield'])) {
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = "SELECT * FROM second_table WHERE someotherfield='".$row['somefield']."'";
$result = mysql_query($query) or die(mysql_error());
mysql_close();
while ($row = mysql_fetch_array($result)) {
*** do whatever you want w/ result ***
}
}
Skeletor
New php-forum User
New php-forum User
 
Posts: 147
Joined: Tue Nov 19, 2002 7:47 am
Location: US, Ohio

Query exact

Postby ruturajv » Wed May 07, 2003 6:21 am

be specific mate
:o
User avatar
ruturajv
php-forum Super User
php-forum Super User
 
Posts: 1280
Joined: Sat Mar 22, 2003 9:42 am
Location: Mumbai, India


Return to PHP coding => General

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.