Databases
in [PHP]
|
explode () and mySQL query I am trying to add a search feature to my shopping cart. I am wanting to use PHP to develop the query for mySQL. I have the following code figured out: foreach(explode(" ", $keyword) as $key) $query .= " $key, "; This produces: WHERE shopping_cart_product.product_description IN ( Jesus, is, Lord, ) The... 4 Jun 2008 02:35
Conditional INNER JOIN Is it possible to do a conditional INNER JOIN ? So far I have SELECT * FROM ( shopping_cart_orders INNER JOIN shopping_cart_sales_shipping_address ON shopping_cart_orders.shipping_address_reference = shopping_cart_sales_shipping_address.reference ) If shopping_cart_sales_shipping_address.same_as_customer h... 26 May 2008 14:39
Partial UPDATE execution? Perl DBI MySQL Has anyone ever seen a partial execution of an UPDATE statement? I'm using Perl DBI to update a table in MySQL. The strangest thing to me is that a varchar(35) field which holds a custom date/time format was updated correctly, but other tinyint(1) fields were not set correctly, and 1 of 3 text fields which were... 22 May 2008 18:51
LIMITiT Hi all, The following code is created by Dreamweaver 8 , it shows 18 records per page. I want to limit the total number of records to 54 that means it should show only the first 3 pages, but as it is not a simple query I can not use LIMIT , it is already used in sprintf. Could someone tell me how can I d... 20 May 2008 14:41
Fwd: PHP 5.2.6 integrating MYSQL 5.0.51b on APACHE 2.0.63 + Windows XP SP2) Did you copy PHP's libmysql.dll to the Apache "bin" directory, restart Apache and tried again? Also add this to your httpd.conf file: Loadfile "C:/php/php5ts.dll" On Thu, May 15, 2008 at 9:48 AM, Jeff88 <ckwoh88(a)yahoo.com> wrote: I had done all that but not working either. Perhaps, I should described in... 15 May 2008 08:23
Fwd: PHP 5.2.6 integrating MYSQL 5.0.51b on APACHE2.0.63 + Windows XP SP2) I had done all that but not working either. Perhaps, I should described in details of what I had done so that you guys and gals can figure out for me where I had gone wrong. a. Installed APACHE 2.0.63 using downloaded file "apache-2.0.63-win32-x86-no_ssl.msi" under "c:\webserver\apache group" directory. Tested... 15 May 2008 21:47
Shopping cart shipping logic I need help writing a mySQL query and syntax that will determine the shipping packing selected and will then determine the cost to ship. I have assigned dollar values to various packaging. I have a designed the following table which contains various packaging, the maximum size (in centimeters) that packaging may ... 15 May 2008 09:56
Fwd: [PHP-DB] PHP 5.2.6 integrating MYSQL 5.0.51b on APACHE 2.0.63 + Windows XP SP2) ---------- Forwarded message ---------- From: Isaak Malik <isooik(a)gmail.com> Date: Wed, May 14, 2008 at 4:07 PM Subject: Re: [PHP-DB] PHP 5.2.6 integrating MYSQL 5.0.51b on APACHE 2.0.63 + Windows XP SP2) To: Jeff88 <ckwoh88(a)yahoo.com> Make sure that you have httpd.conf correctly configured to load the php.in... 14 May 2008 10:34
PHP 5.2.6 integrating MYSQL 5.0.51b on APACHE 2.0.63 +Windows XP SP2) jeff88 wrote: chris smith-9 wrote: Did you restart apache? Stupid question I know but best to check. Any errors in the apache logs? Did you edit the right php.ini file? Look at the phpinfo() page and see which file it's loading from. --- I did restart the Apache and e... 14 May 2008 05:18
Saving an array to a mySQL table I am writing a shopping cart. I am now ready to take the order from being in a session variable $_SESSION['product_selected'][$product_reference_number] to store it into the orders table. While the products selected are being displayed in a loop I have the piece of code $final_order .= $_SESSION['selection... 14 May 2008 00:42 |