Re: [PHP-DB] Splitting a string by a ,

ou need to know is contained in the error message and the introductory paragraph. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -

Re: [PHP-DB] Slashes

a) ... But you would be much better off if you disable all magic_quotes_* and do manual quoting and escaping where necessary. That way you will know exactly what is being done to your data. > then I get a MySQL error > 1064 whenever my value has a single-quote in it. -- Jason Wong -

Re: [PHP-DB] Shift_JIS Character Set

. The shift_jis character set includes a > number of two-byte code charcters that contain the hex-value 0x5c > (backslash) which will get stripped by this function thus garbling those > characters. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems I

Re: [PHP-DB] Shift_JIS Character Set

> quotes and backslashes etc.. so, by right, with English characters, i still > need to stripslashes. OK, if you *know* that the data has been through addslashes() (or equivalent eg magic_quotes_gpc) then doing a strip_slashes() should revert the data to its original form. -- Jason Wong -> Gr

Re: [PHP-DB] More of a question rather than seeking code. :)

t; consuming. [snip] Do yourself a big favour and setup something using a real mailing-list software. Any decent mailing-list manager will handle bounces automatically. Sustained bounces from an email address will eventually lead it to being suspended or unsubscribed automatically. -- Ja

Re: [PHP-DB] Re: Subject: grabbing text from a webpage and putting it in a query.

k it up the archives. If you're requesting a resend of a private mail from Neil, shouldn't you be making this request in private? -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Int

Re: [PHP-DB] Undefined function mysql_connect

/php from source. That way everything can be updated without relying on RH. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development *

Re: [PHP-DB] Re: BINARY not recognized ??

On Tuesday 06 January 2004 03:51, Monty wrote: > Anyone ??? www.mysql.com ??? -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applica

Re: [PHP-DB] file date upload

ay Jan 5, 2004. > > Where can I query to get the timestamp of the upload? If it's uploaded into the filesystem then: manual > Filesystem functions -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Intern

Re: [PHP-DB] Re: BINARY not recognized ??

s over at www.mysql.com, what makes you think us dummies here (I'm speaking for myself) are any wiser? -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -

Re: [PHP-DB] Saving arrays to databases?

serialize() -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -- Search the list archives before you post http://marc.the

Re: [PHP-DB] Database abstraction

elf there are a number of projects which fills the gap. There's the semi-official PEAR-DB, also ADODB and Metabase. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Develop

Re: [PHP-DB] Database abstraction

On Wednesday 14 January 2004 06:42, Martin Marques wrote: > Why is it you say it's semi-official? > I have always felt PEAR as much official. Well it's not in the PHP manual so I treat it as semi-official ;-) -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open S

Re: [PHP-DB] pop, php and mysql problem!

sure you meant to use "email address" somewhere. Anyway, in your code the while-loop and for-loop is essentially looping over the same thing. I hope you're not running a spam factory. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Syst

Re: [PHP-DB] replacing once with ereg_replace

o change the entry to / + entry? Each entry is obviously > different. Using a plus makes MySQL think it's mathematical addition and > sets the field to 0. The field type is varchar. Use MySQL's CONCAT() function. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open S

Re: [PHP-DB] apache/php/mysql - guarenteed DB transaction

_user_abort' setting. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -- Search the list archives before you post http:

Re: [PHP-DB] Building A Query

google, there are plenty around. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -- Search the list archives before you post

Re: [PHP-DB] Multiple values for a column

the column types SET and ENUM. However in general is it better not to store multiple values in a single column, they should be moved into a separate table. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hos

Re: [PHP-DB] mail() and sendmail configuration

.48, PHP 4.3.4, MySQL GUI that creates a [snip] > If anyone has suggestions or knows of helpful links or > tutorials, I'd be deeply obliged. 0) Does the simplest mail() invocation work at all? 1) Check the php logs 2) Check the sendmail logs 3) Ask on the RedHat list 4) Ask

Re: [PHP-DB] help w/ multidementional array in mysql

It returns a value. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -- Search the list archives before you post http:

Re: [PHP-DB] User Authentication

quot;return false" to "return true" in the first script > (login) it authenticates, but logs any one in. Not good. Does anyone > have any ideas or suggestions? You aren't actually performing any queries -- you're missing a mysql_query(). -- Jason Wong -> Gremlins

Re: [PHP-DB] User Authentication

On Friday 27 February 2004 22:42, Craig Hoffman wrote: > Thanks - I can't believe I missed that. :( And I'm sure you'll want to stick in a mysql_error() as well. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Des

Re: [PHP-DB] MySQL query... count?

DISTINCT(bu)buname, COUNT(buname)bucount FROM $table_name > > But it doesn't work.. am I being dumb on this cold Monday morning? Don't use DISTINCT, use GROUP BY. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Des

Re: [PHP-DB] No data being put into the DB

if that causes > problems, but echoing out $addtocart would show that anyway. Also ... > mysql_close(); > $error = mysql_error(); call mysql_error() before you close the connection. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems

Re: [PHP-DB] No data being put into the DB

27;s method myself, for the > color coding that shows > in my editors(Ultraedit and VIM) when concatenating with . , mainly for > readability...but have found myself, of late, using the braces more... The braces syntax highlights fine on Quanta. -- Jason Wong -> Gremlins As

Re: [PHP-DB] Forms and more forms?

elected. print_r() or var_dump() every significant variable. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -- Search th

Re: [PHP-DB] CREATE TABLE $phpVariable_for_tableName <--- help please!

sue with line 3, creating that name Use the concatenation operator, which is a period (.), a + is the mathematical addition operator. Also, always use mysql_error(). -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting *

Re: [PHP-DB] win32 Timestamp problem

und for this bug? Or a way to calculate > age without using the timestamp? As you're asking on the PHP-DB list I would assume that your dates are stored in a database of some sort, in which case you could use your database's native functions to do your date calculations.

Re: [PHP-DB] JPGRAPH, problem...

graph and outputs the image. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -- Search the list archives before you post h

Re: [PHP-DB] BLOB

out ostriches burying their heads in the sand to 'hide' from their enemies? If you don't want to accidently see people's passwords why not just rot13 it (apparently some companies seems to think that is a secure enough form of encryption). -- Jason Wong -> Gremlins Ass

Re: [PHP-DB] INSERT problem--Need help urgently

ute it. Are you doing any redirections or refreshing the page? -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -- Search the

Re: [PHP-DB] INSERT problem--Need help urgently

d } or if (!empty($_GET)) { // form was submitted } In addition you should always perform sanity checks on values of the individual form elements. Search the archives/web for 'sql injection' for more info. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source

Re: [PHP-DB] Drop down menu with PHP

the size of the drop down box so that it displays 2 rows at a time then it is an HTML question and the anwser can be found in any decent HTML reference. Otherwise please elaborate. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web D

Re: [PHP-DB] Stumped with proper query and display

while ($row2 = mysql_fetch_assoc($res2)) { I've no idea what you're trying to do. Are the tables 'cust' and 'contact' related in any way? What is the relation? And shouldn't the relation be reflected in your queries? And if so your second query should be inside

Re: [PHP-DB] Rounding

) function but that rounds up to the nearest > integer.. i need one decimal place still.. multiply by 10 ceil() divide by 10 -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design &am

Re: [PHP-DB] PHP Confused: Using wrong Unix Socket

On Friday 09 April 2004 02:38, Noah Davis wrote: > How can I get PHP to not get confused about which .sock file to use? php.ini > Do I need to recompile PHP? No. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Desi

Re: [PHP-DB] mysql_escape_string()

is in no way related to "metacharacters as defined by the w3c". If you are having a particular problem please elaborate. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applicat

Re: [PHP-DB] mysql_escape_string()

and the string quote character needs to be escaped? -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -- Search the lis

Re: [PHP-DB] Link to do query

; Would I best best to have it something like this: > > http://mydomain.com/profile.php?user=blah ... so just construct your links in a similar manner. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting

Re: [PHP-DB] compile 4.3.6

really e using. > What's interesting is I update another machine with PHP 4.3.5 with GD / > Fink and it work perfectly. Anyone have any ideas? It's only interesting if both machines have the exact same configuration. Otherwise find out what the difference is to figure out

Re: [PHP-DB] Erroneous date and time

4:21 PM > > To the untrained eye ;), that might appear correct. But that was > actually submitted at 11:24 AM, not PM. So, that's my code. Any > suggestions?? Try gmdate() and see whether that gives the expected result. -- Jason Wong -> Gremlins Associates -> www.gremlins

Re: [PHP-DB] adding a mysql query as text into a history table... ?

syntax near '2004-06-23 > 11:09:57', date_modified = '-00-00 00:00:00', date_closed =' at line 6 You'll need to escape the string containing the query before you can insert it. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Softwa

Re: [PHP-DB] [PHP]: session problem

$dt = date("Y-m-d H:i:s"); You should always session_write_close() before you redirect. > header("location: user.php?action=0"); You should be using an absolute URI rather than a relative one. And just to be safe always have an exit() right after your redirect header

Re: [PHP-DB] value error in PHP form

quot;Rinku". Some form elements, eg , are always "isset()" even when you haven't entered anything into them. If you want to check that something has been entered into them then use: if (!empty($POST['doo'] ... but depending on what type of inputs your

Re: [PHP-DB] MySQL query, using DISTINCT...

-01' AND '2004-06-30' would give a mysql error. The correct syntax is: SELECT DISTINCT col1, col2, etc FROM table ... Please follow the examples in the manual and incorporate error checking when using mysql. -- Jason Wong -> Gremlins Associates -> www.gremlins.b

Re: [PHP-DB] Table locking

f some field in a table ? Depends on what type of LOCK you specify. Refer to your DB docs for details. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intrane

Re: [PHP-DB] Table locking

your usual query here UNLOCK TABLES -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -- Search the list arch

Re: [PHP-DB] Multiple SELECT

h string here' *exactly* matches one of the 'username'. You may want to look at the LIKE operator. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development

Re: [PHP-DB] mysql auto increment

ng that page until you have your answer or ask on the mysql mailing list. > I have a primary key in a table the is setup and working > with auto increment. > > Now I want to change it so it will start auto incrementing from 1000. So > each entry will be: > > 1001, then 1002,

Re: [PHP-DB] Easy reg expression problem

zA-Z0-9])@([a-zA-Z0-9]).([a-zA-Z0-9]))", $email, $regs); > print("@".$regs[1].$regs[2].$regs[3]); > > prints @ > > What am I doing/need to do? If you're simply trying to get '@email.com' then use strstr(). -- Jason Wong -> Gremlins Associates -&

Re: [PHP-DB] Easy reg expression problem

On Friday 16 July 2004 08:05, Justin Patrin wrote: > > If you're simply trying to get '@email.com' then use strstr(). > > Of courseI'm just so used to pregs... Well the advantage of using a regex is that you can perform some form of validation on the addr

Re: [PHP-DB] session_start

Secondly, when you use phpinfo() you will see that the ini file you need to edit is called php.ini. Note the path and edit that file, if it's not there then copy one of php.ini-* there. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators *

Re: [PHP-DB] Help. Mysql Query optimisation not very clever?

On Saturday 17 July 2004 09:31, Ross Honniball wrote: > Attention all Sql gurus, > > Is there a way to FORCE mysql resolve specific conditions within a query > before wasting it's time trying to resolve other conditions? www.mysql.com -- Jason Wong -> Gremlins Associates

Re: [PHP-DB] Easy reg expression problem

On Friday 16 July 2004 16:01, Tim Van Wassenhove wrote: > In article <[EMAIL PROTECTED]>, Jason Wong wrote: > > On Friday 16 July 2004 08:05, Justin Patrin wrote: > >> > If you're simply trying to get '@email.com' then use strstr(). > >> > >

Re: [PHP-DB] howto get PK id after INSERT??

On Tuesday 20 July 2004 10:09, Vincent Jordan wrote: > Is there a way to get the ID (custid PK UNIQUE AUTO_INCREMENT) from > mysql after INSERT then pass to final page using urlencode to pull cust > record? manual > MySQL Functions -- Jason Wong -> Gremlins Associates -> www

Re: [PHP-DB] DB access failure...

OSTS file. Or setup your DNS properly. Or just use the IP address. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -- Se

Re: [PHP-DB] Wait Statement... ?

one in normal html code... WHy don't you just validate the login and be done with? Why wait 1 second, another second, ... ? -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications De

Re: [PHP-DB] howto get PK id after INSERT??

T LAST_INSERT_ID() from customerinfo"); mysql_query() returns a "resource id". > $last_id = urlencode ($last_id); > header("Location: UserMain.php?custid='$last_id'"); So the above is meaningless. Please check the previous responses where you have been

Re: Re[2]: [PHP-DB] Wait Statement... ?

On Wednesday 21 July 2004 05:00, Pablo M. Rivas wrote: >sleep() is the brute deffense of the brute force attack... >You can make a script that opens simultaneous attacks One thing to bear in mind is that sleep() will hog resources and can lead to DOS. -- Jason Wong ->

Re: [PHP-DB] Concurrent rutines

You have started a new thread by taking an existing posting and replying to it while you changed the subject. That is bad, because it breaks threading. Whenever you reply to a message, your mail client generates a "References:" header that tells all recipients which posting(s) your posting refers

Re: [PHP-DB] What's wrong with this QUERY??

eir values enclosed by quotes. > The email address does exist exactly as quoted above in the "email" field > in my "members" table but still doesn't produce any results. mysql_error() would let you know that there was an error in your query. -- Jason Wong -> Grem

Re: [PHP-DB] DB access failure...

will be no difference whether you connect using IP address or hostname. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * --

Re: [PHP-DB] DB access failure...

rres.ws' Well that sounds like something, somewhere is not using the system's DNS resolve mechanism. As I don't have a Windows box handy I'm afraid I cannot help you. > Sometimes things are not done for "practical purposes." Right. -- Jason Wong -> Gremlins Asso

Re: [PHP-DB] Empty query result

x27; page. However, I just want it to move on. For > example, if there is no 'phone2' given in the database, I want it to > just assign $phone2 to zero/nothing, not go to the error page. Well you wrote the code so that it will go to the error page. -- Jason Wong -> Gremlins

Re: [PHP-DB] Re: form results to email

On Saturday 31 July 2004 23:25, Vincent Jordan wrote: > I have tried to add some html such as "$firstname $lastname > ..."; however when I do this there is nothing displated in > the email message. google > html mime message Or look on www.phpclasses.org --

Re: [PHP-DB] Enabling LDAP support

ight make it work... but it didn't. So HOW didn't it work? > Anyone have any suggestions b/c I'm stuck? 1) post some *concise* code that illustrates your problem 2) state exactly what and how it is not working 3) post any error messages that you get (having first made sure th

Re: [PHP-DB] Re: LAMP

rage of data (involving few relationships) then MySQL is more than sufficient and a tried and tested solution. This probably covers the vast majority of the data storage needs of web apps. No sense in going for a DB with features you're never ever going to use and is probably slower to boot

Re: [PHP-DB] Re: LAMP

equate for their needs - An app they want to use only supports MySQL - Their host only supports MySQL > SQLite is a different matter and the obvious new base for beginners, but > for real applications ... Use Postgresql! -- Jason Wong -> Gremlins Associates -> www.gremlins.biz

Re: [PHP-DB] Re: LAMP

of the hardware ;) Hmm, if I'm not mistaken, I think he means that *unless* you have a big cheque book to pay for Oracle then MySQL is the next fastest thing around. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design &

Re: [PHP-DB] Re: sendmail

hing to look at would be the mail logs. That would tell you whether a mail was injected into the queue. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * --

Re: [PHP-DB] "Last monday" query question

t doesn't seem to work all the time. Any ideas? Use strtotime() and maybe PHP's other date/time functions then plug into your query. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Interne

Re: [PHP-DB] Re: Exporting Data From MySQL Using PHP

nce, = and LIKE have different purposes. Refer to manual and/or some SQL tutorial for details. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -

Re: [PHP-DB] I'm not getting any mailing list messages

heck whether any messages have been posted to the list then have a look at the archives. Messages to the list will appear in the archives almost immediately. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hos

Re: [PHP-DB] SMTP

hen. > > > [mail function] > > ; For Win32 only. > > SMTP = localhost > > SMTP = 587 I believe the 587 is the port number to use. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators

Re: [PHP-DB] SMTP

On Tuesday 17 August 2004 12:58, Jason Wong wrote: > On Tuesday 17 August 2004 14:07, John Holmes wrote: > > > In the Outgoing mail (SMTP): field, change the number that displays to > > > 587. > > > > I guess "587" is the name of AOL's outgoing S

Re: [PHP-DB] SMTP

way (your ISP may have blocked port 25) - thus you are forced to send your mail through your ISP's SMTP server. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet &a

Re: [PHP-DB] Check Boxes

question concerning sql queries and accepting info from POST, GET etc have security implications if data is not sanitised. Where do you begin? Where do you end? -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * In

Re: [PHP-DB] Re: MySQL denying access to everything

SQL manual. Uninstalling would depend on how you installed it in the first place. And in any case this isn't the list for discussing how to install and configure MySQL. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Ho

Re: [PHP-DB] Tricky MySQL / php Script

cordset based on the > user's id? Assuming you have already created your 'recordset': loop through recordset looking for 'photoID' when found, use mysql_data_seek() to grab the previous and next records -- Jason Wong -> Gremlins Associates -> www.gremlins.

Re: [PHP-DB]different heading

where's the problem? If you insist, you can use something like: SELECT clumsy_column_name AS goodname FROM ... Refer to MySQL documentation for more info. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Intern

Re: [PHP-DB] letting a table name be a constant

l problem rather than on your typos. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -- Search the list archives befor

Re: [PHP-DB] New to the list

alues and not the database / tables > I wish to use. Have php pull the data required, have php output the appropriate javascript code using the pulled data _instead_ of the 'preformatted values'. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Softw

Re: [PHP-DB] mySQL searching through serialized arrays

unction to filter through > the serialized array You're not using the database properly. Have a separate table where each record contains a user_id and the record_id to which it is linked. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems I

Re: [PHP-DB] Question on Registration Method

me on what extra security this method provides over and above the following more simple methods: - Send user a system generated password with which they can login and subsequently change. - Send user an activation link which once clicked on would activate them and allow them to

Re: [PHP-DB] Question on Registration Method

change. OR > > - Send user an activation link which once clicked on > > would activate them and > > allow them to choose a password. What is the advantage in sending someone a password AND making them click on a link to activate? -- Jason Wong -> Gremlins Associates -> w

Re: [PHP-DB] PHP compile error: Cannot find mysql header files

On Monday 11 October 2004 09:49, andy wrote: First, read manual > MySQL Functions Second, decide whether you want to compile using the bundled MySQL library. If so the above tells all you need to know. If not you need to install the devel package for MySQL. -- Jason Wong -> Gr

Re: [PHP-DB] Don't mean to be repetitive - Session Variables

On Monday 11 October 2004 16:47, Stuart Felenstein wrote: > I can't seem to figure this out. > Right now I'm still trying to get the multi page form > down. > For the facts, running php 4.3.8, apache 1.3.x > Register Globals are enabled If you don't have a specific reason for this to be enabled yo

Re: [PHP-DB] Don't mean to be repetitive - Session Variables

er can change with the form input ? The 'something' in your particular case is the data from the form on Page1. Eg $_SESSION['variable'] = $_POST['myforminput']; -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators *

Re: [PHP-DB] Don't mean to be repetitive - Session Variables

d (not registered, and even if it was registered you have nothing to put in it just yet) and hence setting your field value to it is meaningless. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intran

Re: [PHP-DB] DB will INSERT wont UPDATE..error in code?

when $sql is defined like so: > $sql = "UPDATE badges SET staff = '".$HTTP_POST_VARS["staff"]."' ttlpst = > '".$HTTP_POST_VARS["ttlpst"]."' mnthpst = '".$HTTP_POST_VARS["mnthpst"]."' &g

Re: [PHP-DB] DB will INSERT wont UPDATE..error in code?

ERE fid = 61Query3 failed: You > have an error in your SQL syntax near 'ttlpst ='1' mnthpst = '1' ttlicon = > 'trophie' at line 3 If you look up the manual entry for UPDATE, you'll find that you're missing the commas separating the

Re: [PHP-DB] how to connect to dbase

impossible. I may be wrong, but I can't believe that dbase is exactly popular amongst php users. Its lack of popularity could explain the lack of response. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosti

Re: [PHP-DB] Addslashes / DB Sort

ipslashes function is being used on data coming from the database. You're not supposed to use stripslashes() on data coming from the database -- read up on addslashes() and also search manual for magic quotes. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Sof

Re: [PHP-DB] How to send a SID in a security way

27;stay in the session', the session id has to be propagated from page to page whether by cookies, URL or form. In other words you *have* to send it one way or another. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design &

Re: [PHP-DB] Implementing search in a database driven website

; > Any pointers. manual > Regular Expression Functions (Perl-Compatible) > Pattern Modifiers -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * -

Re: [PHP-DB] MySQL backup software

On Wednesday 27 October 2004 13:57, Perry, Matthew (Fire Marshal's Office) wrote: > Does anyone know a free MySQL backup program to schedule regular backups? www.mysql.com google > mysql mailing list -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source

Re: [PHP-DB] printer dialouge box

On Saturday 30 October 2004 12:33, balwantsingh wrote: > how i can open the printer dialouge box of browser in PHP. pls. help. You don't because you can't. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design &

Re: [PHP-DB] PHP & Javascript

at the values can be > displayed in next page. You can pass values from client-side using Javascript either via the URL ($_GET) or form ($_POST) or cookies ($_COOKIE). You can't manipulate the session variables directly. -- Jason Wong -> Gremlins Associates -> www.gremlins.b

Re: [PHP-DB] Problems with mysql_num-rows()

On Sunday 31 October 2004 18:32, Arne Essa Madsen wrote: > I have the following problem: > > This one does not work: > $query = "SELECT * from user where name='$userid' and > pass=password('$password')"; print $query; > $result = mysql_query($qu

Re: [PHP-DB] Something wierd with time() and curdate()

rrectly then a few lines of code showing the date calculations would be sufficient. If you suspect MySQL is the culprit then a single query would be sufficient. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design

  1   2   3   4   5   6   7   >