Posted by pete M on 10/04/83 11:08

Check out abstraction layers

I use adodb
http://adodb.sourceforge.net/

makes coding much much easier ;-))

eg - mysql example
$sql = "insert into table (col, col2)values('$this','$that')";
$db->execute $sql;

// get last id
$new_id = $db->getOne('select last_insert_id()');

have fun
Pete

ross@aztechost.com wrote:
> Is there a way to retrieve and display a single value (customer number) from
> a database and display it without using
>
> while ($row = mysql_fetch_array) ($result)){
>
>
> I have a value I know the query will only ever return a single value. I want
> to get it from the database and convert it to a variable so I can use it on
> my php page.
>
>
> Thanks in advance,
>
> Ross

• Prev in thread: Re: [PHP] retrieve single field from database without while loop
• Next in forum: Re: paring large files - PHP or Perl
• Prev in forum: Re: php error
• Thread view: retrieve single field from database without while loop

[Reply to this message]