Search found 16 matches

by pilsy2001
Thu Aug 24, 2006 8:00 pm
Forum: PHP - Code
Topic: Postcode Script - Help
Replies: 28
Views: 3182

Everah wrote:LIKE expects a string I think. You are probably going to need to change that comparison.
so i have to create a variable with a Search String in it an then link it to the query like '%$variable%' ??
What would the search string have to roughly look like?

Thanks
by pilsy2001
Wed Aug 23, 2006 10:58 pm
Forum: PHP - Code
Topic: Postcode Script - Help
Replies: 28
Views: 3182

You can use like, but I would seriously consider changing your table layout to take advantage of the relationship capabilites.... How would you suggest improving the database, there needs to be one row in the database that holds all the information for each store... the only other way of getting ar...
by pilsy2001
Thu Aug 17, 2006 9:15 pm
Forum: PHP - Code
Topic: Help with Account Levels in PHP
Replies: 3
Views: 342

switch ($admin_account_level) { case 1: //do something break: case 2: //do something else break; default: //do something else yet again } is this the code i need to use in the second file? how is the switch activated? is it possible to add a Param to the URL and use it with PHP_SELF? Thanks
by pilsy2001
Wed Aug 09, 2006 11:00 pm
Forum: PHP - Code
Topic: Help with Account Levels in PHP
Replies: 3
Views: 342

feel free to jump in anytime guys... :lol:
by pilsy2001
Tue Aug 08, 2006 10:06 pm
Forum: PHP - Code
Topic: Help with Account Levels in PHP
Replies: 3
Views: 342

Help with Account Levels in PHP

feyd | Please use , and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color] Hi Guys, ...
by pilsy2001
Thu Jul 20, 2006 12:02 am
Forum: PHP - Code
Topic: Postcode Script - Help
Replies: 28
Views: 3182

:roll: hey everah, i have stumbled onto another problem... I store all the postcodes in one row and coloum on the database for each store, for instance it would read Storename | postcodes -------------------------- Store1 | 4432, 4353, 3423, 2623, 2363, 2352 ... I store all the postcodes in that dat...
by pilsy2001
Mon Jul 10, 2006 10:35 pm
Forum: PHP - Code
Topic: Postcode Script - Help
Replies: 28
Views: 3182

That worked perfectly, thanks everah! :D
by pilsy2001
Mon Jul 10, 2006 7:36 pm
Forum: PHP - Code
Topic: Postcode Script - Help
Replies: 28
Views: 3182

// *****************************************************// // Modification for Post Code Script for Franchises BOF // //******************************************************// $query_postcode = "SELECT a.entry_postcode, a.customers_id, f.store_postcode, f.store_email FROM address_book a INNER...
by pilsy2001
Sun Jul 09, 2006 8:52 pm
Forum: PHP - Code
Topic: Postcode Script - Help
Replies: 28
Views: 3182

done, done and done :)

Edited: im an idiot
Thanks again, :lol:
by pilsy2001
Sun Jul 09, 2006 7:15 pm
Forum: PHP - Code
Topic: Postcode Script - Help
Replies: 28
Views: 3182

sql ="SELECT a.entry_postcode, a.customers_id, f.store_postcode, f.store_email FROM address_book a INNER JOIN franchises f ON a.entry_postcode = f.store_postcode WHERE a.customers_id = '$customerid'" This code here works perfectly!! Now i just need to figure out the code on how to get my ...
by pilsy2001
Thu Jul 06, 2006 10:35 pm
Forum: PHP - Code
Topic: Postcode Script - Help
Replies: 28
Views: 3182

Unknown column 'postcode' in 'field list'

That is a no go :cry:
by pilsy2001
Thu Jul 06, 2006 9:55 pm
Forum: PHP - Code
Topic: Postcode Script - Help
Replies: 28
Views: 3182

Unknown table 'f' in field list

Database name "catalog"
Franchise Table: franchises
Addressbook table: address_book

Sorry about this, not so great at php at the moment
by pilsy2001
Thu Jul 06, 2006 8:54 pm
Forum: PHP - Code
Topic: Postcode Script - Help
Replies: 28
Views: 3182

What I would do is clean the tables first. You want to keep information related to one specific group in that groups table. You reference that group by the group id in the other tables as needed. Then, use a join query to get what you want in one array... <?php $sql = "SELECT a.entry_postcode,...
by pilsy2001
Thu Jul 06, 2006 12:01 am
Forum: PHP - Code
Topic: Postcode Script - Help
Replies: 28
Views: 3182

Below is a MYSQL DUMP (structure only) from my database, -- phpMyAdmin SQL Dump -- version 2.6.4-pl3 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jul 06, 2006 at 02:56 PM -- Server version: 4.1.14 -- PHP Version: 4.4.0 -- -- Database: `catalog` -- -- -----------------------...
by pilsy2001
Mon Jul 03, 2006 11:03 pm
Forum: PHP - Code
Topic: Postcode Script - Help
Replies: 28
Views: 3182

Thanks Everah your a legend :wink: Can i ask you one other question? I have 2 tables inside the database at this point in time, $check_post_code_customer = "SELECT entry_postcode FROM address_book WHERE entry_postcode ='$customerpostcode'" $check_post_code_store = "SELECT postcode, st...