mysql query generator tool?? - GoFuckYourself.com

mrthumbs · 03-04-2004, 11:21 PM

is there some sort of simple tool that can do this:

i insert a few variables
testa
testb
testc

and the tool auto generates this query:
$query=mysql_query("insert into whatever (testa, testb testc) values ('$testa','$testb','$testc')");

which i can simply cut and paste into my php script..

Its a bitch creating those queries with tables over
30 fields...

Otherwise ill build it myself but maybe......???

senseidru · 03-05-2004, 05:38 AM

I know phpmyadmin has a tool for generating queries on sql tables. But I love to do it manually.

sexsup · 03-05-2004, 07:12 AM

Quote:

Originally posted by senseidru
...But I love to do it manually.

It's a sort of perversion

grumpy · 03-05-2004, 08:15 AM

contact me...i can do that :-)

FiReC · 03-05-2004, 08:18 AM

MS access has the ability to build queries using their gui.

Repetitive Monkey · 03-05-2004, 08:34 AM

I'll make it in PHP if you wish... Would take me a whole 30 seconds.

mrthumbs · 03-05-2004, 08:39 AM

replies came in a bit late so i already made my own tool
to generate INSERT and UPDATE queries..

this is going to be a big time saver!!

Repetitive Monkey · 03-05-2004, 08:41 AM

Quote:

Originally posted by mrthumbs
replies came in a bit late so i already made my own tool
to generate INSERT and UPDATE queries..

this is going to be a big time saver!!

Can you please donate some postcounts to me?

senseidru · 03-06-2004, 04:17 AM

Quote:

Originally posted by sexsup
It's a sort of perversion

xroach · 03-06-2004, 05:26 AM

03-04-2004, 11:21 PM	#1
mrthumbs salad tossing sig guy Join Date: Apr 2002 Location: mrthumbs*gmail.com Posts: 11,702	mysql query generator tool?? is there some sort of simple tool that can do this: i insert a few variables testa testb testc and the tool auto generates this query: $query=mysql_query("insert into whatever (testa, testb testc) values ('$testa','$testb','$testc')"); which i can simply cut and paste into my php script.. Its a bitch creating those queries with tables over 30 fields... Otherwise ill build it myself but maybe......???

03-05-2004, 05:38 AM	#2
senseidru Confirmed User Join Date: Sep 2002 Location: UKStyle.UKFlow Posts: 1,767	I know phpmyadmin has a tool for generating queries on sql tables. But I love to do it manually. __________________

03-05-2004, 08:15 AM	#4
grumpy Too lazy to set a custom title Join Date: Jan 2002 Location: Holland Posts: 9,870	contact me...i can do that :-) __________________ Don't let greediness blur your vision \| You gotta let some shit slide icq - 441-456-888

03-05-2004, 08:18 AM	#5
FiReC Confirmed User Industry Role: Join Date: Jan 2002 Location: Land o Nubiles Posts: 2,350	MS access has the ability to build queries using their gui. __________________ www.nubilefilms.com \| www.nubiles.net \| www.anilos.com \| tubescript.nubiles.net \| icq4162727

03-06-2004, 05:26 AM	#10
xroach Confirmed User Join Date: Feb 2002 Location: vancouver, bc Posts: 963	weak

03-05-2004, 08:34 AM	#6
Repetitive Monkey Confirmed User Join Date: Feb 2004 Posts: 3,505	I'll make it in PHP if you wish... Would take me a whole 30 seconds.

03-05-2004, 08:39 AM	#7
mrthumbs salad tossing sig guy Join Date: Apr 2002 Location: mrthumbs*gmail.com Posts: 11,702	replies came in a bit late so i already made my own tool to generate INSERT and UPDATE queries.. this is going to be a big time saver!!