forumnz

I have created a design for a client. It is in the form of an image at the moment. www.designervision.co.nz/webuy2 The client wanted a clean, simple website. Colors: Orange/yellow, blue text. He wanted it similar to www.dhgate.com but more modern and appropriate. Is it good/bad? What would improve it? Thanks Sam

There is another website that I want to collect details off. There are pages of details each with a unique number, so the pages look like ...com/Page.php?number=12345 Each page has the same information on it, just customised for each page (like name, date etc) How would I go about creating a PHP script to collect all the data and store it in my database. I am a confident user of PHP so I will undertsand, I just haven't done this before. Thanks, Sam

Can I copy files from server A to server B assuming I have all the necessary FTP details etc? And can every file file be copied if the folder containing them is copied? Thanks! Sam

I have this script I wrote to set cookies. Why doesn't it work? It just says "500 Internal Server Error". Thanks. <?php $m025to039 = $_POST['m025to039']; $m090to099 = $_POST['m090to099']; $m040to049 = $_POST['m040to049']; $m100to149 = $_POST['m100to149']; $m050to068 = $_POST['m050to068']; $m150to199 = $_POST['m150to199']; $m069to079 = $_POST['m069to079']; $m200to299 = $_POST['m200to299']; $m080to089 = $_POST['m080to089']; $m300plus = $_POST['m300plus']; $cur = $_POST['currency']; setcookie("m025to039", $m025to039); setcookie("m090to099", $m090to099); setcookie("m040to049", $m040to049); setcookie("m100to149", $m100to149); setcookie("m050to068", $m050to068); setcookie("m150to199", $m150to199); setcookie("m069to079", $m069to079); setcookie("m200to299", $m200to299); setcookie("m080to089", $m080to089); setcookie("m300plus", $m300plus); setcookie("curr", $cur); header("Location Search.php?m=s"); ?>

I want to select * from a database where unit is equal to either A or B. How is this done? Would it be... WHERE unit BETWEEN A AND B...? Thanks Sam

How can this be done. Let's say there is a from with a dropdown box with an option to select from database where id is between 20-30. How is this done? Would it be ...... WHERE `id`="20-30"......? Or what? Thanks! Sam.

Can PHPMyAdmin create PHP code to create tables? Thanks heaps! Sam.

Hi, this website is targeted towards small businesses and website designers. Does it look appealing to that demographic? Thanks - www.sitequote.co.nz

Hope this makes sense?

Can it?

I want to update a db row +15.. This is what I have so far.. mysql_query("UPDATE webdevscon SET bal = +15 WHERE id='$wdid'"); Why won't this work?

How do I get last month (May), to display? I tried date(F-1), but that didn't work. Thanks, Sam.

How can this be done? Like for example if I wanted to display from Jan to Jun. Thanks, Sam.

<? $result = mysql_query("SELECT * FROM requests WHERE MONTH(acctime) = '06' ORDER BY id ASC"); ?> Thats the part that is having the trouble. Thanks, Sam.

I have a table in a database, and I want to select all the rows with a datetime between two dates.. for example from the start of June until now.. how do I do this in a mysql query? Thanks! Sam.

Thanks everyone!

Thanks..but what if I want it to be a variable? Like if in the end I want $numbers to equal '1,2,3,4,5'. How is that done?

I want to SELECT numbers FROM a database WHERE user='user'...I know how to do that... but lets say there is 5 rows with that user... how can I display the number from each one like this 1,2,3,4,5 ? Just the numbers with a comma in between? Hope this makes sense! Thanks! Sam.

THANK YOU!! THANK YOU!! THANK YOU!! THANK YOU!! Sam ;D

How can this be done? For example if I wanted to get the rows in a database, with id's 1,5,37 and 95. How can this be done? Thanks! Sam.

I dont see what is wrong with this: <? $con = mysql_connect("localhost","aaaaa","aaaaa"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("aaaaa", $con); $result = mysql_query("SELECT * FROM accepted WHERE bid='$wdid' AND reqid='$rid"); $num_rows = mysql_num_rows($result); echo $num_rows; ?> I get this error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/www/vhosts/sitequote.co.nz/httpdocs/Members/ViewRequest.php on line 76 Thanks!

Hi I want to have a line break. How would I do this? Thanks heaps! Sam.

I use PHP to get some data from a database and display it. The text that is displayed goes on for too long. How do I use CSS to make it shorter? The div is 150px wide and I want the text to stay within that and not overflow. Thanks, Sam.

When someone goes to my website I 'example.com' instead of being http, I want it to go to https. How do I do this? Using FTP I had 2 folders.. One was httpdocs and the other was httpsdocs, so I put an index file in the httpdocs folder that redirects to https://www.mysite.com/ but it say that the page is never going to complete. What should I do instead?

How can I generate a random 32 character string?