Can i do this?

ajdegans

Will this work?

Yes i know i should just try it... but its a installer file and im not ready with it yet... so i cannot really test it 🙂

$smiley29="INSERT INTO `smileys` VALUES (28, '(l)', 'wub.gif')";
$smiley30="INSERT INTO `smileys` VALUES (29, ':-)', 'smile.gif')";
mysql_query($smiley,$smiley2) or die(mysql_error());

Thanks in advance?😃

devinemke

BSTRhino

devinemke's short answer there is correct, but probably an explanation is what you were looking for?

$smiley29="INSERT INTO `smileys` VALUES (28, '(l)', 'wub.gif')"; 
$smiley30="INSERT INTO `smileys` VALUES (29, ':-)', 'smile.gif')"; 
mysql_query($smiley,$smiley2) or die(mysql_error());

The first thing I noticed was, the syntax to mysql_query() is: mysql_query($queryString, $resourceLinkIdentifier). So, it looks like what you've got there doesn't match that syntax.

Also, I believe the queries you wanted to run were in $smiley29 and $smiley30, but your mysql_query() statement doesn't have any reference to $smiley29 or $smiley30, so you probably won't get the results you want.

Both the query statements look correct however, so to run them, you'd need to have two mysql_query statements, one running $smiley29, and the second running $smiley30

ajdegans

yes, i see that too. i was in a hurry when typing this thread 🙁

Anyway, the thing is i want to insert 30 rows in a dbtable with 1 query.... as described in my 1st thread...

thought the code there has the wrong variables... 🙂

BSTRhino

In mySQL you can do this:

INSERT INTO `smileys` VALUES (28, '(l)', 'wub.gif'), (29, ':-)', 'smile.gif')

ajdegans

i will give it a try soon 🙂 thanks!