mysql_fetch_array prob

Anon

hi i\'m trying to extract var\'s from one table

if (!($conn = db_connect()))
return false;
$result = mysql_query( \"select *
from user
where email = \'$valid_user\'\");
$row = mysql_fetch_array($result); //getting info from row in db

$userid = $row[\'userid\'];
$firstname = $row[\'firstname\'];
$middlename = $row[\'middlename\'];
$lastname = $row[\'lastname\'];

//then extract info from another row in the db using one of the var\'s i extracted in the first sql query

$result = mysql_query( \"select *
from mjp1
where userid = $userid\");
$row2 = mysql_fetch_array($result); //getting info from row in db

$maidenname = $row2[\'maidenname\'];

//the last part doesn\'t seem to be working. it\'s not pulling up the value for $maidenname in the second table. i get no errors. am i going about this the right way?

thanks
g.o.p.

neleus

You may need to convert the array field $row->userid to a string before the SQL select can use it in a query.

$userid = (string)$row->userid

The other thing you may want to do also is make your second $result something else. I have had problems with sql statements in the past and two $result variables.

Anon

thank you sir

i'll try it out

Anon

i tried. i don't know if i did the conversion from array to string correctly

if (!($conn = db_connect()))
return false;
$result = mysql_query( "select *
from user
where email = '$valid_user'");
$row = mysql_fetch_array($result); //getting info from row in db

$userid = $row['userid'];
$firstname = $row['firstname'];
$middlename = $row['middlename'];
$lastname = $row['lastname'];
$userid = (string)$row['userid']->userid; //does this look right? i've also tried '$userid = (string)$row->userid;

$result2 = mysql_query( "select *
from mjp1
where userid = '$userid'");
$row2 = mysql_fetch_array($result); //getting info from row in db

$maidenname = $row2['maidenname'];

still not pulling up maidenname, does the string conversion line look right?

thanks
poss

neleus

The second string convert should have worked. Try specifying the fields you want to pull instead of "SELECT ". I have also had problems in the past with msyql_fetch_array with a SELECT .. it seems you are only wanting a few fields, so try ..

SELECT userid,firstname,middlename,lastname FROM user where email = '$valid_user'

with the $user = (string)$row->userid;

and then SELECT maidenname from mjp1
where userid = '$userid'

not tested ..

Hope it works for ya