nested sql query

hyster

i have 2 tables and i search table 1 col1 for the col2 data.

table 2, col1 has the data i need to produce the report.

im having trouble passing a variable from 1 query to the 2nd.

//1st query
$sql="select * from spl WHERE orsku LIKE '$srch' LIMIT 1";
$result=mysql_query($sql);
$rows=mysql_fetch_array($result);
$passon=$rows['orsku'];

//2nd query
$sql1="select * from dsgi WHERE reconsku LIKE ($passon)";
$result1=mysql_query($sql1);

while($rows=mysql_fetch_array($result1)){

}

i have tested the 2nd query with fixed piece of data and its ok. i think the problem is passing the data from query1 to query2.

thanks for any help

bradgrafelman

Why not use a single query? Something like..

SELECT d.col1, d.col2
FROM spl s LEFT JOIN dsgi d ON s.orsku = d.reconsku
WHERE s.orsku LIKE '$srch'
LIMIT 1

Few things to note:

Don't use 'SELECT *' - only SELECT the columns that you actually need data from. For example, you'll have to change the 'col1, col2' stuff above to the appropriate columns that you need data from.
Why are you using a LIKE statement in the first query? Does $srch utilize wildcard characters?
Once you retrieve the 'orsku' value from the first table, why are you using the LIKE clause again in the second query?
Your syntax for the 'LIKE' clause is incorrect in the second query.

hyster

im very new to sql and php and im cobbaling together code from diffrent scripts.

i need to get the row info from table 2.

im using $reconsku to get which row.

im getting $reconsku from table 1 col2 (thats the data that links the tables)

im getting col2 from col1.

col1 is a unique number which must be searched for ( $srch)

what ive tryed to do is.

$srch to col1 - col2= $orsku --- $reconsku to row i need ( $orsku and $reconsku are the same data

$srch = wildcard

im using like for the orsku as if the data is supposed to be 002406 then some times the 00 are missing. so 002406 will be listed as 2406.

another way to say it

spl table= spl , orsku, make, pallet

dsgi table= origsku, reconsku, make, model, working, actions

i need to search for tbl,spl for a unique number - take the orsku data and use it to get the data from dsgi,reconsku.

then echo the row from dsgi with the tbl,spl

sorry if this dosent make sense. i can visualize what i need but im finding it hard to explain as i dont no the correct termonology.

thanks for help.