ashishag67

IF you can tell how have you scheduled your cronjob? what control panel has the server provided?

why dont you try this $client_q=mysql_query("SELECT * FROM organisations o, hosting h where o.organisation_Id=h.server_id='1'") or die(mysql_error()); $client=mysql_fetch_array($client_q); $total_users=mysql_num_rows($client_q); Do let me know if this works. Cheers

<?php $db = odbc_connect("asas","asass","asasa"); $sql = "SELECT id, url FROM foto"; $res = odbc_exec($db, $sql); while ($row = odbc_fetch_assoc($res)) { ?> <img src="<?php echo $row['url'];?>"> <?php } odbc_free_result($res); odbc_close($db); ?>

I suggest try if(!isset($image)) or if($image=="")

<?php $db = odbc_connect("asas","asass","asasa"); $sql = "SELECT id, url FROM foto"; $res = odbc_exec($db, $sql); while ($row = odbc_fetch_array($res)) { ?> <?php echo $row['id'];?>, <img src="<?php echo $row['url'];?>">, <?php echo $row['time'] . "\n";?> <?php } odbc_free_result($res); odbc_close($db); ?> Please try this code, if it works do let me know. Cheers

It is further more simple follow the links below: http://mysqlandphp.net/viewtopic.php?f=3&t=24 You can first search for an ip address $_SERVER['REMOTE_ADDR']) and with the ip address you can filter the country and city and using if command you will be easily able to restrict page. Cheers,

$query=mysql_query("SELECT * FROM listings li, listings_url lurl where li.search_text LIKE '%$value_to_find%' AND li.live='1' AND lurl.listing_id='".$ad_id['id']."'"); Try this out will work Cheers

Try this may help <?php function bowob_link(){ ?> <li><h2>Chat <img align=\"absmiddle\" src=\"L4DTchatIcon.png\" title=\"L4DT Chat\" alt=\"L4DT Chat\"/></h2> <?php bowob_link_rooms(); echo "</li>\n"; } ?>

Try this may help <?php function bowob_link(){ ?> <li><h2>Chat <img align=\"absmiddle\" src=\"L4DTchatIcon.png\" title=\"L4DT Chat\" alt=\"L4DT Chat\"/></h2> <?php bowob_link_rooms(); echo "</li>\n"; } ?>

You can try this <option value="<?php echo $row['ID'];?>" <?php if(!strcmp($row['ID'], $row['ID'])) echo "selected";?>><?php echo $row['Title'];?></option> Hope this works for you. Cheers

else { ?> <h4 align="center"><u>Lastest IT News</u></h4> <marquee height="100%" scrollamount="2" direction="up" loop="true"> <font color="#ffffff" size="2"> <center> <strong> <?php echo file_get_contents("../news.hza"); ?> </strong> </center> </font> </marquee> <?php } ?> just copy paste this code and i am sure it should work! cheers Enjoy! Visit http://www.mysqlandphp.net

Try this code in case if it works SELECT * FROM product_category_associations, products where product_category_associations.product_id = products.id AND products.date_available <= '2008-11-05' and products.product LIKE '%Sample%' AND `december` !=0 AND product_category_associations.live =1 GROUP BY `linked_id` ORDER BY product_category_associations.live DESC For mysql help for visit at http://mysqlandphp.net

Please check the things below in order to debug this issue: 1. sesssion_start() should be present at the top of every page wherever session is involved. 2. check by declaring one more session variable and see if the value for that variable is received at the next module. 3. Check if the session variable you are using is not getting a null value while moving from one module to another... visit me at http://www.mysqlandphp.net

Hey I suppose i can solve your problem.. I have recently started a new forum website called http://www.mysqlandphp.net.. This website will provide you from basic as to install php to beginning php... try it out..

hey salami1_1 creating database is a pain in a neck if done with coding I would suggest use phpmyadmin... it comes with a bundle in wampserver which consist of apache, php , mysql, postgre this will solve your problems with foreign key as well.. check this website: http://www.mysqlandphp.net

This code will help you:- first upload the csv file at a location into csv folder $uploaddir = 'csv/'; $uploadfile = $uploaddir . basename($_FILES['file']['name']); $find=".csv"; $str=$_FILES['file']['name']; $pos=strpos($str, $find); if (move_uploaded_file($_FILES['file']['tmp_name'], $uploadfile)) { $msg="File is valid, and was successfully uploaded."; } else { $msg="Possible file upload attack!"; } //file has been uploaded now import the file contents to the db $handle = fopen($uploadfile, "r"); while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $num = count($data); $row++; for ($c=0; $c < $num; $c++) { echo $data[$c] . "<br />\n"; } //the csv file contains two data i.e. $data[0] contains name field and $data[1] contains email field $name=$data[0]; $emailID=$data[1]; $query=mysql_query("SELECT * FROM details where emailID='$emailID'"); $n=mysql_num_rows($query); if($n==0) { $query=mysql_query("INSERT INTO `details`(`name`, `emailID`) VALUES('$name', '$emailID')"); $ins++; } } fclose($handle); ?> cheer! enjoy check this website http://www.mysqlandphp.net

What method is paypal asking inorder to process the transaction. You can also use 2 forms instead. i.e. the first form with dropdown will pass the value to the second form wherein you can post the value from the first to the second page where in you can also declare a form variable with hidden field with respective drop down value.. //page1.php <form method=post action=page2.php> <select name=txtAmt> <option value="1000">1000</option> <option value="2000">2000</option> <input type=submit value="Submit" name=submit> </form> //page2.php <form method=post action="pagename.php"> <input type=hidden name=txtAmount value="<?php echo $_POST['txtAmt'];?>"> <input type=submit name=submit value="Confirm Order"> </form> Hope this helps you also check http://www.mysqlandphp.net

You will find good stuffs at w3school.com which will guide you from the basic. You can also try mysqlandphp.net which will teach you the basic of html, php and mysql. Also installing of apache server etc... enjoy