Search results for query: *

ooo.. Thanks for that Harley! I haven tried it yet but am sure it will work. Thanks a bunch!

...rota becomes active. My code below only display the current rota, but once its sunday morning, the rota automatically disapear where I want it to remain active until midnight. SELECT * from rota WHERE `date`>NOW() ORDER BY `date` ASC LIMIT 1 All help much appreciated in advance, Thank...

Never mind. Thanks for your help. I've got it working now.

Thanks Justin. I found this code on my Hosting company's website ini_set("sendmail_from", "info@seeme.co.uk"); How can I integrate this into my existing code?

...I usually use Linux Server which works fine with the code below <p>Thank you <strong><?php echo($name);?> </strong> <?php /* This section tries to send the form, if successful a successful message is displayed if not, an error message is diplayed. the r\n write the next...

I've just gone to my Hosting company's website to check if its possible to change my php.ini file and this is what they had on their support page What other direction possible? thanks a lot

ok, i've just created a test.php with the code above this is what I found on the configuration detail. error_reporting 2047 2047 display_errors On On display_startup_errors Off Off in addition, how will I go about editting this file? do I have to contact my Hosting company? Many Thanks

Justin, Am not that advance yet, sorry. How do I turn on display_errors and set error_reporting to E_ALL or E_STRICT? I dont get errors on the page, it just dosnt display the records on the database. basically, its meant to grab all the records on the table where session_id = $cart_id etc...

Thanks for that Justin, The problem is not even on the sessions it seems because when I echo out the query it seems fine. My guess is the while loop but I just dont know what it is. any suggestion with that? Thanks once more

...or die ("cannot connect to database ".mysql_error()); $sessionid = "$cart_id" ; $sql = " SELECT Sum(products.product_price * ylabelcart.quantity) AS total, ylabelcart.`session` FROM products INNER JOIN ylabelcart ON...

Thanks Justin, Works fine. Thanks once more.

I've got, user title image id As the fields in my database. My point here is that, should it matter if I have odd number data on the tables? shouldnt it be that even if there were8 records there would be two rows with three records and the last row with just two? What I want displayed was...

In addition to the above problem, the code is not code is not also allowing me to display associated data below each record which is the aim really ie, Id:112 | Id002 | id005 William John Julie Am not sure if you would understand the above example. Thanks Justin

Sorry there are 4 records on my table. but its still suppose to move to the next line dosnt it?

Any idea why its not looping through? its only coming up with the first 3 records even though there are 8 records in total and its suppose to move to the next three records and the next 3 etc.

...like now. <?php require_once('Connections/Connection.php');?> <?php mysql_select_db($database_Connection, $Connection); $sql = "SELECT * FROM videos"; $results = mysql_query($sql) or die("Something Wrong Mate"); $returnedrows = mysql_num_rows($results); $num_cols = 3; echo...

Update: I changed the code a little to $sql = "SELECT * FROM videos"; $result=mysql_query($sql) or die ("Query Error: " . mysql_error()); Now I just Get the error message: Query Error: No database selected Which is very wiered. any sugestions? Thanks

...$i++;){ Here is another version I was toying around with <?php require_once('Connections/Connection.php');?> <?php $sql = "SELECT * FROM videos"; $results = mysql_query($sql) or die("Something Wrong Mate"); $returnedrows = mysql_num_rows($results); if($returnedrows > 0) { //...

Hi, I've always wondered how this is done and cant seems to grasp it. When I query my DB, how can I go about displaying each record with its attributes i.e Student one name DOB etc, Then Student 2 Name DOB etc, Student 3 Name DOB etc before creating a new row and repeat the process? Basically...

Hi Justin, Itsworking now!!! thanks a million. The problem was the session value wasnt passing through. I changed the session from if (session_name() == '') {session_start();} to this version if(!isset($HTTP_COOKIE_VARS['cart_id'])) { $cart_id = md5(uniqid(rand()))...