Or: http://www.aspseek.org/
Per
Ron Piggott [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I wanted to also ask about how you would build a web site search engine
with
php and mySQL.
I had thought of setting up a table with a few columns ---
one for the URL of the specific page
Dear friends,
Any guidance to the error , please.
--
---
Warning: Unexpected character in input: '\' (ASCII=92) state=1 in
C:\HOME\doctorbush\check.php on line 11
Parse error: parse error, unexpected
Hi,
--- [EMAIL PROTECTED] wrote:
Dear friends,
Any guidance to the error , please.
--
---
Warning: Unexpected character in input: '\'
(ASCII=92) state=1 in
C:\HOME\doctorbush\check.php on line 11
Parse
Dear friends,
Any guidance to the error , please.
Resubmitting,
--
---
Warning: Unexpected character in input: '\' (ASCII=92) state=1 in
C:\HOME\doctorbush\check.php on line 11
Parse error: parse error, unexpected
[EMAIL PROTECTED] wrote:
Any guidance to the error , please.
Resubmitting,
--
---
Warning: Unexpected character in input: '\' (ASCII=92) state=1 in
C:\HOME\doctorbush\check.php on line 11
Parse error: parse error,
http://www.phpdig.net/
Uses both PHP and MySQL.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Joseph are you saying Orase uses phpdig?
No. Only that phpdig uses PHP MySQL.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Just curious, but what kind of field is everyone using to store a Zip Code.
I set mine to Medium Integer with a max of 5 digits, but for zip codes that
begins with 0 the 0 is knocked off. The only solutiuon I can think of is to
make the field a text field. Does anyone have a better solution?
Are you only accepting US zip codes?
Justin
-Original Message-
From: Aaron Todd [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 08, 2004 8:36 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Zip Code Fields
Just curious, but what kind of field is everyone using to store a Zip
Code.
I
With MySQL you could do this:
MEDIUMINT(5) UNSIGNED ZEROFILL
Most databases (I think) would have an equivalent of this if you're
using something else.
Chris
Aaron Todd wrote:
Just curious, but what kind of field is everyone using to store a Zip Code.
I set mine to Medium Integer with a max of 5
I have several tables with long numbers whose digits are always in some
multiple of 8 eg or etc...up to 160 digits long.
The numbers all have a number of digits that is some multiple of 8. What I
need to do is write an sql update query that will insert a - or some other
you can store it as an integer, but make sure you use a proper print function
to display it later that preserves the 5 digits, such as:
echo str_pad($zip, 5, 0, STR_PAD_LEFT);
or something like that.. I take it you have no plans to store 10 digit zips?
-Micah
On Wednesday 08
Doesn't the USPS have some online API for checking Zip Codes? Not sure but I thought
I read about it somewhere.
look here
http://www.usps.com/webtools/
-Original Message-
From: Justin Palmer [EMAIL PROTECTED]
Sent: Sep 8, 2004 12:25 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Zip
From: Shiloh Madsen [EMAIL PROTECTED]
I have several tables with long numbers whose digits are always in some
multiple of 8 eg or etc...up to 160 digits long.
The numbers all have a number of digits that is some multiple of 8. What I
need to do is write an sql update
I'm using a product called dbqwiksite pro. PHP
generator for PHP - MySQL
The code seems to be working fine except in my search
page where I receive an invalid query
$result = mysql_query($sql . . $sql_ext . limit
0,1)
or die(Invalid query);
This is the place I where the code is taking the
What are the variables $sql and $sql_ext set to? The query format is
fine. It's probably in your variables.
--
Peter Ellis - [EMAIL PROTECTED]
Web Design and Development Consultant
naturalaxis | http://www.naturalaxis.com/
On Wed, 2004-09-08 at 12:29 -0700, Stuart Felenstein wrote:
I'm using
In addition, please send your messages once and only once. I have two
copies of the same e-mail, both sent to the list successfully with two
different replies to both messages. You're more likely to get help if
you post and wait for a reply to your original message.
--
Peter Ellis - [EMAIL
HI
try
$result = mysql_query($sql . . $sql_ext . limit 0,1)
or die(Invalid query.mysql_error());
which will give more detail on the error.
HTH
Peter
-Original Message-
From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
Sent: 08 September 2004 20:29
To: [EMAIL PROTECTED]
Not sure what the varialbe are set too. Going through
the code and rebuilding the query.
Post on hold to further notice :).
Stuart
--- Peter Ellis [EMAIL PROTECTED] wrote:
What are the variables $sql and $sql_ext set to?
The query format is
fine. It's probably in your variables.
--
Change the code to this:
$result = mysql_query($sql . . $sql_ext . limit 0,1) or
die(mysql_error().br.$sql. .$sql_ext . limit 0,1br);
And you'll get the error from mysql and a copy of the actual query. Without
that, it's pretty tough to help.
-Micah
On Wednesday 08 September 2004
What exactly is in the $sql and $sql_ext??
Try to put it into a variable so you can print out what you're sending
to the DB
Such as:
$query = $sql . . $sql_ext . limit 0,1;
Echo $query . BR;
If your $sql and $sql_ext combine to make a valid sql query, the is
just putting a space inside the
What's contained in $sql and $sql_ext ???
Stuart Felenstein wrote:
I'm using a product called dbqwiksite pro. PHP
generator for PHP - MySQL
The code seems to be working fine except in my search
page where I receive an invalid query
$result = mysql_query($sql . . $sql_ext . limit
0,1)
or
K, first off I'm brand new to PHP and databases. So I
hope my question isn't stupid or unfitting to the
list.
Welcome! Only those that don't ask are unfitting
I am creating a search and results page of, right
now 3 fields with more to add.
Perhaps not necessary to my question, I have
Robert Twitty wrote:
On Thu, 19 Aug 2004, Gerard Samuel wrote:
Robert Twitty wrote:
Hi
Is anyone using PHP to connect to an IBM DB2 database? The reason why I
am asking is becaouse I want to see if the odbtp extension can be used to
successfully prepare and execute DB2 stored procedures. So
hi,
I have two tables
say customer_tbl and record_tbl
the customer table stores all details abt the customer like name , id
, address, email etc and the record table stores the daily records of
the customer like id, marks_scored, total marks, date etc ..
in the reports.php page i display the
25 matches
Mail list logo