Hi
No you can't.
if you are using and AUTO_INCREMENT field as a key you could follow the
INSERT with a select statement like:
"SELECT * FROM tablename WHERE keyfield = LAST_INSERT_ID()"
See the manual: LAST_INSERT_ID()
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Mis
Get your VB Manuals out, or test your programme against an Access Data Base.
Once you have issed an Update statement, you need to either retrieve the record
for further update or set all the fields then issue the Update statement!
This is very 'Off Topic"
Clive Smart
Kelvin Lam wrote:
> Hi,
>
Hi Alex,
Try the following:
if ($submit) {
/* process form */
if($namequery = mysql_query("SELECT * FROM rahs WHERE name='$name'") {
while($set=mysql_fetch_array($namequery)) {
printf ( "Name: %s",$set["playername"]);
printf ("$stat: %s",$set[$stat]);
}
} e
>From the PHP home page:
PHP Security Update
[27-Feb-2002] Due to a security issue found in all versions of PHP
(including 3.x and
4.x), a new version of PHP has been released. Details about the security
issue are
available at http://security.e-matters.de/advisories/012002.html.
All users of PHP
Drop the quotes (') arround the NULL
e.g.: 7,'Markovic Stevo',NULL,NULL
Clive Smart
WEBServ
TomazSa wrote:
> I get *.csv file like this (1 string) :
>
> 7,'Markovic Stevo','NULL','NULL'
>
> When I use LOAD DATA INFILE syntax I get word NULL in field (MySQL table)
>
> q: I want field to be empty
Sorry, No Green Beer, No can do that ;-)
Richard Reina wrote:
> I am try to do a join with tables that are in two different databases.
>
> I thing I've got the actual SQL syntax down:
>
> my $q = "SELECT i.inv_no, i.inv_date,
> c.cust_name
> FROM receivables.invoice i, sales.cust