MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:abdulazeez alugo Date:April 20 2009 12:23pm
Subject:RE: Need help with mysql prob
View as plain text  
> Date: Mon, 20 Apr 2009 13:03:14 +0100
> From: andy-lists@stripped
> To: defatigue@stripped
> CC: mysql@stripped
> Subject: Re: Need help with mysql prob
> 
> Hi Alugo,
> 
> abdulazeez alugo wrote:
> >
> > Hi Andy,
> > Thank you very much you have been really very helpful. All those 
> > mistakes you pointed at in the script about the apostrophe and others, 
> > are simple mistakes I just made in the rush of typing the message; and 
> > yes $conn is the result from mysql_connect. In my original script I 
> > clean my script to avoid mysql injection.
> 
> No worries, just thought I'd point it out in case ;-)
> 
> > However, if you look at the code very well, you'll realize that I have 
> > stored the result of the mysql_insert-id($conn) in a php variable 
> > $tbl1_id and this is defined within a function *newPost_tbl1($id, 
> > $entry, $text).* My problem now is how to access that variable in the 
> > function that inserts into the child table so that I'll have the same 
> > value for tbl1_id in tbl1 and tbl1_id in tbl2.
> 
> Why not just return it from the function?
> 
> ....
> $tbl1_id = mysql_insert_id();
> return $tbl1_id;
> ....
> 
> Then in the code that calls newPost_tbl1 ...
> 
> $tbl1_id = newPost_tbl1($id, $entry, $text);
> newPost_tbl2($tbl1_id, ....);
> 
> Regards,
> Andy
> 
Thank you very much Andy,

Now my problem is solved.

Cheers.

Alugo Abdulazeez.

_________________________________________________________________
Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy!
http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us
Thread
Need help with mysql probabdulazeez alugo19 Apr
  • Re: Need help with mysql probAndy Shellam19 Apr
    • RE: Need help with mysql probabdulazeez alugo20 Apr
      • Re: Need help with mysql probAndy Shellam20 Apr
        • RE: Need help with mysql probabdulazeez alugo20 Apr
          • Re: Need help with mysql probAndy Shellam20 Apr
            • RE: Need help with mysql probabdulazeez alugo20 Apr
              • Re: Need help with mysql probAndy Shellam20 Apr
                • RE: Need help with mysql probabdulazeez alugo20 Apr
  • Re: Need help with mysql probTom Nugent20 Apr