[PHP-DB] MySQL problem

2002-02-21 Thread Caleb Walker
I keep on getting this error statement: Warning: Supplied argument is not a valid MySQL result resource in /usr/local/www/data/phone/insert2.php on line 10 2 Can someone tell me what is wrong with the code below, I just cannot figure it out... Thank you very much in advance. I am using php4.

Re: [PHP-DB] select from two tables

2002-08-03 Thread Caleb Walker
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I did not look at the code very much but if you want to select from 2 tables your sql statement is like this: select a.col1,b.col1 from table1 a,table2 b where a.column=b.column && column='value'; I think that if this is what you are looking for th

Re: [PHP-DB] line breaks in mySQL text fields

2001-07-25 Thread Caleb Walker
On Monday 23 July 2001 11:16 am, kmurrah wrote: > How do I add new line characters to a text field in mySQL ? > > i.e. i need to manually insert "returns" into my text ... > > thanks in advance, > > KennM Does the "\n" not work? I dont have time to try it write now but did you try it? -- PHP

Re: [PHP-DB] 'htaccess" method : how to modify passwords from PHP scripts ?

2001-07-25 Thread Caleb Walker
On Tuesday 24 July 2001 10:22 am, JD Daniels wrote: > There is a fantastic class that takes care of writing .ht* files... look > here: > > http://phpclasses.upperdesign.com/ > Couldnt find anything on writing .ht* files. Are you sure? -- PHP Database Mailing List (http://www.php.net/) To unsubs

Re: [PHP-DB] Retrieving Rows - Can I Change The Order?

2001-07-27 Thread Caleb Walker
> Now then, I have changed a column in the table, and the only way I found to > change a data type is to delete the offending column and then add it again. > > When I do the select now the new column, which was at $row[3] is now always > $row[39]. I don't mind this, because I know where it is, bu

[PHP-DB] start over on database read inorder to read from the beggining again

2001-08-13 Thread Caleb Walker
How can I run through a database like I am trying to do here? It seems like at the end of the first I need to start over in order to start reading from the beggining of the database on the second. I hope that I hace explained my problem well if not please reply with your questions. Thank you

[PHP-DB] problem with mysql_data_seek() fuction

2001-08-14 Thread Caleb Walker
Warning: Offset 0 is invalid for MySQL result index 2 in /usr/local/www/data/football/front/index2.php on line 20 When using mysql_data_seek($result,0) why do I get the above error in the source code of the html that is produced? Another side point is that this does not display on my webpage

[PHP-DB] format dates from a database

2001-08-18 Thread Caleb Walker
I am wondering if there is an easier way to format dates that come out of a database. My database stores my date in the format- "-MM-DD". I know that I can take this and rearrange it with some string manipulation but is there any other easier way to do that say like making it say Sep. 09,