Search results for query: *

Sorry about the vague post at the begining. You are right I didn't include all the details as I should have. The script I am looking for doesn't matter if it is ASP or php, all I want it to do is to enter data in to the fields of a mysql table (just one table in the DB), I prefer not to have...

why would I be kidding! I am aware of phpMyadmin but that is to complex and it might effect the integrity of the DB if I let every tom dick and harry use it. I just thought that there may already be a ready made script that some one has used and that they might recommend that just enters the...

Hi I was wondering if any body has stumbled across a script/code that allows data entry on to a mysql table using a webpage, and wouldn't mind sharing it with me. Many thanks M

Hi I would like to exclude a value from list of variable values from an SQL expression. Let's say I have a list of categories and I want all of them to be shown except one how can i do that? The values are numerical. Many Thanks

Thanks for your response, I manage to cracj it eventualy, as you mentioned in one of your posts I finally decided to incorporate an ASP code in the page which will do the mutipliction using the Euro value from the property tableand the CER from the cer table. Thanks for all your time and...

Can a calcullation be done in a web page using ASP where let say field1 is multiplied by field 2 from a certain mysql table? What code would one use? Thanks

Thanks for your reply. I am using ASP, I have looked at running a second query but its kind of difficult relating the prices to the properties(it becomes all jumbled up), as I can't think of a way to incorporate the CER primary key(id) into the property table. I was also thinking along the...

I am designing a property web site, using mysql on dreamweaver, I have four tables, one with property details, one with property location, one with property type and another with current exchange rates. As you can probably see from the query below I have managed to creat a recordset with...

Your suggestion does make a lot of sense. I would like to give it a try, the problem I have though is that I would like to implement this on to a web site having never done any calculations on mysql, I would appreciate if you could let me know what would be the best way to start? Thank you fopr...

Hi I would like to know if it's possible to have a field data calculated based on the data of another field. Let's say I have a Euro column which I enter data into directly but I would also like to have USD and GBP columns, is there a way where I can add a formula so that when I enter data into...

I managed to sort the problem out it wasn't the code, It was the WYSIWYG editor meesing things about, when I started over it all worked fine. Thanks for trying Cheers Mehdi

I think this is the code you mean Thanks for your reply <% set Rslts = Server.CreateObject(&quot;ADODB.Recordset&quot;) Rslts.ActiveConnection = MM_connSqlproperty_STRING Rslts.Source = &quot;SELECT property.*,location.Location,proptype.PType FROM property,location,proptype WHERE...

Hi I am developing a website using ASP VB Script, I was using an Access Database to begin with but then decided to switch over to MySQL as I found out was some what superior. After swaping over the recordset I keep getting the following error, do you think that the error could be due to the...

Thank you for that, I managed to link my database. Regards

Hi I would like to link an Access 2000 DB to a MySQL Server which is connected to UltraDev, I know how to export tables but I need to know if the two can be linked in any way so the data is updated simultaneously, I need this as the site I am creating requires regular update. Regards