gvp16

hmm...thats not something ive done before, the table is to contain a string in each cell, would it still work for that? also how would I for example remove column 2 from your example (2,2)? Thanks

I have a table with x ammount of rows and x ammount of columns, in each TD there is an input box which the user fills in, when they press save the information is input into the database in this form at 6,1,2,3,4,5,6,A,1,2,3,4,5,6,B,1,2,3,4,5,6 - the first number is the number of columns, 1- 6 is the top line of TDs (column headers) and then A 1-6 is row 1, B 1-6 is row 2 etc.. so i then out put the information into a table via a for loop : while($row = mysql_fetch_array($r)) { $data = explode(',',$row["content_bottom"]); $datacount = count($data); echo"<table border='1'><tr><td>Tool Type</td>"; $k = 1; for ($i = 1; $i <= $datacount; $i++) { if($data[$i] !=""){ echo "<td>".$data[$i]."</td>"; if($k == $data[0]-1) { echo"</tr><tr>"; $k = -1; } $k++; } } echo"</table>"; I can see how i would delete a row of information, eg delete B 1-6, but any ideas how I could delete a column? or is there a better way of storing this information?

eg. write and if statement or something that checks the results and orders them based on if they area whole word etc...?

Hi, im doing a search which looks like this : if(isset($_GET["q"]) && $_GET["q"] !="")// get the search string { $words = explode(" ",$_GET["q"]);//explode on the spaces $count = count($words); for($i =0; $i<= $count; $i++) { if($words[$i] !="") { $qt .= "(description LIKE '%".addslashes($words[$i])."%' OR "; //build sql query $qt.= "productcode like '%".addslashes($words[$i])."%' ) AND "; } } $q = "select * FROM Main WHERE $qt stock > 0 AND wholesale = '1' AND itemStatus = '1' LIMIT 15";//run search the search works exactly as we want it, so it picks up any words with the key word in. But how can i order the results by relevance, eg. if i searched for "cat" i would get results like : dreamcatcher cat box cats picture how could i order the results so the whole word is at the top? eg. cat box casts picture dream catcher Thanks

How? if part1 = 3641-001 part2 = 3646-001 part3 = 3647-001 how are they duplicated?

can you please explain how that will help? each row already has its own identifier and there are no duplicates.

Hi, all, I have a table that has a list of kits and their parts like so : KitCode, KitPrice, Part1, Part2, Part3, Part4, Part5, Part6, Part7, Part8, Part9, i then have a shopping basket with parts in: Part1 Part2 Part3 How can search to find it a kit has all the parts i have in my basket? Thanks.

Have been told this by my host I've spent a little while looking in to this module this morning, the modules quite outdated so we wouldn't be able to install it for a few reasons a) this module is not available via easyApache b) this module is not safe for shared hosting a VPS or Dedicated server is recommended c) this module is dated and will not work with PHP 5.3 only older versions such as PHP 4 I would recommend you look at another solution for your script or application. Thanks.

Thanks, ill take a look, would that require root access on the server to install? because I dont think I have that as I am on shared hosting. Thanks.

Does anyone know of any open source packages to upload video to a your website similar to the facebook or youtube one? eg. where it will convert file types etc...? or can this be done in PHP? I know you could just use file upload to upload the video, but that wouldnt really a solution would it. Thanks.

Thanks very much guys, done what I needed.

Hi, how can I match two keywords in a string? eg. if keywords (Kids,Hoody) are in this string (Animal Kids Basic Hoody Blue) do something..... Thanks.

Hi, Ive got 3 tables in a database barcode, products, prices the 3 tables link the data via a product code, so each table has a "productCode" feild. Im looking to put them into a single table containing the contents and fieids from all the tables. BUT! there is data in some tables that isnt in other ones that I would like to save, so for example, there may be a barcode and product, but no price. or a product and no barcode or price. Anyone know how i can do this? Thanks.

ive cracked it! needed to use my server IP address and add the ip address of the connecting server to the remote mysql option in cpanel! Thanks anyway

I normally enter "localhost" as all sites at the moment are hosted on the same server, but im looking to connect a site on a different server to my database. This is the error Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'glowormd_geraint'@'MANCLINUX2.NETWORKDNS.BIZ' (using password: YES) in /home/glowormd/public_html/www.xxxxxxx.com/global.php on line 6 Could not open database Thanks.

access denied is the error, just checked.

I think it said couldn't connect

Hi, I have a reseller hosting account, on which I have a mysql database. how can i connect to the database from a different domain? Ive seen before that when connecting with php you can use the IP address of the server. Or wont this work in this case? Thanks.

Works perfect! thanks

Im using a php session to keep a user logged on, after about half hour of inactivity the user gets logged out. i think the javascript part is working correctly as it loads the file that makes the image. Ive read that just refreshing an image isnt enough to keep a session alive as it is on the server and would need a server interaction, hence the php script to generate the image. its a bit of both question. Thanks.

Hi all, ive got a bit of code that im using to try and keep a session alive but its not working, it uses javascript to refresh an 1x1 px image generated by php. I had this working on a previous project but no longer have the source code for it. Heres what I have. <------main.php-----> <SCRIPT language="JavaScript" type="text/javascript"> var t = 300 // interval in seconds image = "blank1x1.php" //name of the image function Start() { tmp = new Date(); tmp = "?"+tmp.getTime() document.images["refresh"].src = image+tmp setTimeout("Start()", t*1000) } Start(); </SCRIPT> <------blank1x1.php-----> <? $img = imagecreate( 1, 1 ); header( "Content-type: image/jpeg" ); imagejpeg($img); imagedestroy($img); ?> any help would be great, thanks.

Thanks for that, but i just cant get my head round how i check all the rows and colums for the correct combination

Hi guys, i need to make a suduko solver that completes the grid when you enter some of the numbers. but i cant quite figure out how to do it, one way i can think is to compare all the values from the input boxes in a row/ column, and if they add up to the total then it is correct, but im sure there is a better/ more dynamic way. I dont want someone to do the work for me, just a point in the write direction. Thanks.

thanks for that, ive got it working where www.mysite.com/page/about goes to www.mysite.com/index.php?page=about but how i do it when a real directory is involved? eg www.mysite.com/content/5 would go to www.mysite.com/content/index.php?id=5

Hi, thanks for the quick reply, im guessing its not as simple as just putting that code into the htaccess. im new to htacess so im not really sure what im doing, but im guessing that I have to set up my links slightly different and then that code rewrites them to make them look better?