Thanks jpadie.
I'll start work on this and post questions on the relevant forums.
Cheers.
Rajeev
UK's best mobile deals online
http://www.bargainmobileshop.com
Sorry, use this url for the image:
http://picasaweb.google.com/rajeev.ja/SiteDesign#
UK's best mobile deals online
http://www.bargainmobileshop.comhttp://picasaweb.google.com/rajeev.ja/SiteDesign#
Hello folks
I'm trying to create a new design for a php website to make it database driven (MySQL).
I can play around a bit with php and mysql but not really an expert. I'm seeking advice/tips on how best to achieve my site design (attached)
* Fig 1 shows the landing page with initial data...
Ok. Looked at MySQL reference manual and figured out how to do it.
Here it is:
update mytable set model_number = substring_index(product_name,' T-Mobile ',1) where network = 'T-Mobile';
This worked beautifully.
UK's best mobile deals online
http://www.bargainmobileshop.com
Hello
I'm having a problem with an incorrect datafeed received.
Following is an example.
product_name column has this.
W880i Silver T-Mobile FLEXT 35 18 months
I now want to extract 'W880i Silver' which appears before T-Mobile and update the model_number column. This string can vary from...
Hi
I'm a newbie with ruby. Have an installation of ruby 1.8.4 on windows xp (for some test automation stuff). From here I would like to query some tables on our postgresql DB on a remote linux box.
What do I need to do to query the postgresql db on linux using ruby on windows ?
Thanks for...
Hi folks
We are trying to automate some tests for our web application for which we are evaluating a test tool 'watir' which supports ruby.
We are able to invoke the browser using the watir library and playback few tests which is fine.
Now, when the browser goes to the login screen (using...
Hi there
I've setup a readymade website on my Win XP. It's running Apache 2.2 and PHP5.
When I run index.php, there is an error displayed
Notice: Undefined variable: auto_filename in F:\wwwroot\ecommerce\index.php on line 154
index.php has the following line
<? include("includes/vars.inc")...
Now resolved. I did the following.
Downloaded mysql extension (PHP 5.2.0) from
http://dev.mysql.com/downloads/connector/php/
Unzipped the dlls into c:\php5 (my php install directory) as by default extension_dir = "./" in php.ini
Uncommented extension=php_mysql.dll in php.ini
Restarted...
Hi Vacunita
The following is set in the php.ini
extension_dir = "./" and both php_mysqli.dll and libmysql.dll are present in the C:\php5 directory.
Also entered in php.ini
extension=php_mysqli.dll
extension=libmysql.dll
Still complains about the same.
Thanks
Rajeev
UK's best mobile deals...
Hello Guys
I'm a newbie with php and mysql. I found a couple of tutorials on the web and got a small test script which confirms that php connects to mysql server correctly.
Here's the test script -
-------------------
<?php
mysql_connect("localhost","root","tester") or die(mysql_error());
echo...
Hi There
I'm creating a dynamic web page for my company after running a few shell scripts from the main program.
What's happenning is - two of these scripts take a while longer to finish and hence the output does not appear on the page. This gives an impression to the user that the page has...
Brilliant. Both work perfectly well.
Appreciate your helpw ith this.
Thanks a lot.
Regards
Raj
UK's best mobile deals online
http://www.bargainmobileshop.com
Well, some people claim that sqlplus does not return ZERO for SUCCESS always. So, our guys decided they are going to use 99 as our success code. Lot of other stuff depend on the exit status of 99.
Secondly, in this case, I would also like to store the result of the query in a shell variable...
Hi Dagon
Did think about it. But like to avoid running the query twice. Will have that as an option if nothing else works out.
Thanks
Raj
UK's best mobile deals online
http://www.bargainmobileshop.com
Hi There
I'm running an sql query from within a shell script.
We use a different exit code to denote SUCCESS (99) rather than 0.
The code is something like this (assuming only 1 row is returned) -
-------------------------------------
temp_percent="set pages 0
set head off
whenever sqlerror...
Thanks a lot everyone for inputs. Solved by using the file command piped thru grep for compressed. If result 0, gunzip, else, continue.
UK's best mobile deals online
http://www.bargainmobileshop.com
Hi Guys
Hope you can help me with this.
I have to deal with a set of file that come in everyday.
Example
x1
x2
x3.gz
x4.gz
x5.gz
x6.gz
x7.gz
x8
x9
x10
In the example above, I have to pick the oldest file from the list and process it (x1, x2, x3, etc). However, to save on space, there is a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.