[PHP] mysql_num_rows always returns 1?

2002-06-18 Thread Mark Colvin
The function below works when I pass in a valid username and password and returns '1'. When I pass a username and password that is not in the database it still returns '1'. I have put some echo statements in for debugging and the value of $numresult is always '1'. Does mysql_num_rows retain

[PHP] Submitting Form Data

2002-07-03 Thread Mark Colvin
I have a php script that performs a query and then dynamically builds a section of a page for every row returned. Each section has some fields and three submit buttons. My problem is this. If I make a change to one particular section, how can I submit the form passing only the relevant section

[PHP] Button can't see form!

2002-07-04 Thread Mark Colvin
I use the following line in some of my php scripts to navigate between pages: td align=left width=40pxinput type='button' class='bginput' value='New' onClick=this.form.action='newproduct.php?mode=new'; this.form.submit()/td The problem I have is with a page I build dynamically. The whole page

[PHP] PHP Image Functions

2002-07-09 Thread Mark Colvin
I have a directory of jpegs that I want to display thumbnails of and have a link to the original jpeg. I would rather not create separate thumbnails images preferring to create them in memory to display them. I have installed GD v.1.8.4. The code below outputs jumbled text to the browser

RE: [PHP] PHP Image Functions

2002-07-09 Thread Mark Colvin
Thanks for your reply. Its a bit further forward but still not working. I have split the files and the output now shows the text part of 'img alt=text src=...' ie it won't recognise the image. Anything else you can think of? This e-mail is

RE: [PHP] PHP Image Functions

2002-07-09 Thread Mark Colvin
That's the winner!! Everything working good now. Thanks again. This e-mail is intended for the recipient only and may contain confidential information. If you are not the intended recipient then you should reply to the sender and take no

[PHP] Displaying Database Results

2002-07-12 Thread Mark Colvin
I have a php script that queries a MySQL database and I loop through the results displaying them as follows: echo td width='100'input name='description' type='text' size='45' maxlength='20' value=.StripSlashes(mysql_result($badgedetails, $i, 'descr')). tabindex='1'//td; The problem is that as

[PHP] Forms problem?

2002-07-17 Thread Mark Colvin
I have a php script that queries a mysql db and build a form on a page for each row returned. Each form has four fields and a thumbnail of a JPEG. Below the image is a link to view the full image in a new window by using a javascript function. (No javascript jibes before I go any further, it was

[PHP] Upload File Problem

2002-07-18 Thread Mark Colvin
I have a simple script that attempts to upload a file and save it on the server. When I click send file I get this error message 'Warning: Unable to open '' for reading: No such file or directory in /var/www/html/upload.php on line 5 Couldn't copy the file!'. The file is being uploaded from a Win

RE: [PHP] Upload File Problem

2002-07-18 Thread Mark Colvin
Joakim, Thank you for your reply. I tried your example and get 'Possible file upload attack: filename.' meaning that 'if (is_uploaded_file($_FILES['img1']['tmp_name']))' returns false. I put a couple of echo statements in before the if statement to check '$img1_name' '$img1_size and '$img1_type'

RE: [PHP] Upload File Problem

2002-07-18 Thread Mark Colvin
Joakim, Thanks again. $HTTP_POST did the trick. I did look through the archives before posting but didn't come across this solution. I obviously didn't look hard enough! This e-mail is intended for the recipient only and may contain

[PHP] PHP Installation Problem

2002-07-30 Thread Mark Colvin
I have a development web server php 4.0.6 apache and mysql and everything works OK. I installed the same software onto a new server that will be the production server but I hit problems when my scripts try and hit the db on the new server. Comparing the phpinfo details for both, the new server

[PHP] PHP Installation Problem

2002-07-31 Thread Mark Colvin
Thanks all. I have now resolved. For future reference, the problem was as you said, I didn't have php configured for mysql support. I traced this back to the installation of the operating system, Red Hat 7.2. Through the graphical installation, all php modules apart from mysql support and odbc

[PHP] StripSlashes Problem

2002-08-02 Thread Mark Colvin
I use the following php code to build a dynamic table retrieving values from a MySQL databases that have been inserted with slashes added - echo td width='100'input name='descr' type='text' size='45' maxlength='20' readonly value='.StripSlashes(mysql_result($badgedetails, $i, 'descr')).'

RE: [PHP] StripSlashes Problem

2002-08-02 Thread Mark Colvin
John, Thank you for your reply. My magic_quotes_runtime is set to 'Off'. As you said, I shouldn't have to use StripSlashes but would I still need to use AddSlashes when inserting/updating? I can see the slashes in the database when I look at the tables but I am fairly sure that I do not add

RE: [PHP] StripSlashes Problem

2002-08-02 Thread Mark Colvin
John, Thank you. This solves the problem. Petre, Thank you for your reply. I wasn't aware of the difference and will bear this in mind. This e-mail is intended for the recipient only and may contain confidential information. If you are

[PHP] Mail problem

2002-08-30 Thread Mark Colvin
The script below works on my development web server which sits on our company LAN. When I transfer the script to our isp hosted webserver, the script does not work. I changed 192.168.10.9/iarnaweb/ to read localhost/ for the isp webserver version (I have also tried replacing localhost with the

RE: [PHP] Re: Mail problem

2002-08-30 Thread Mark Colvin
Manuel, My development platform is linux 7.2 and php4.0.6. The production server is also linux (I think 7.2) but the php version 4.1.1. On your second point, do you mean I should say something like this - header(Location: http://ccmltdcouk.site.securepod.com/test.php;) This is our temporary

RE: [PHP] Re: Mail problem

2002-08-30 Thread Mark Colvin
I have some more information that may be relevant to my problem. I compared the phpinfo() from both servers and there is a difference. The sendmail_from variable in the php.ini on my server is set to [EMAIL PROTECTED] The same variable on my isp's ini file is set to 'no value'. Would this stop my

RE: [PHP] Re: Mail problem

2002-08-30 Thread Mark Colvin
Still not resolved. I checked my local php.ini and the sendmail_path variable is commented out. If I do a phpinfo() on the same server, sendmail_path has a value of /usr/sbin/sendmail -t -i ? I don't know where it pick up this value from but I can send emails from this server. The production

RE: [PHP] Re: Mail problem

2002-08-30 Thread Mark Colvin
Erwin, sendmail on my local server does indeed reside in /usr/lib/sendmail although phpinfo shows sendmail_path = /usr/sbin/sendmail -t -i it still sends the mail? Why is this the case and would you suggest anything to enable me to get my mail working with my isp. I do not have direct access to

RE: [PHP] Re: Mail problem

2002-08-30 Thread Mark Colvin
I have this set on both boxes. Here are the settings - local box (which does send mail)isp box (does not send mail) sendmail_from melocalhost.com 'no value' sendmail_path /usr/sbin/sendmail -t -i/usr/sbin/sendmail -t -i SMTP

RE: [PHP] About html

2002-08-30 Thread Mark Colvin
Use the tabindex - td width=100 valign=topinput name=telno type=text size=60 maxlength=60 value= tabindex=1//td -Original Message- From: kale [mailto:[EMAIL PROTECTED]] Sent: 30 August 2002 08:45 To: [EMAIL PROTECTED] Subject: [PHP] About html Hy, I have one question about html.

[PHP] Informix Connection

2002-10-03 Thread Mark Colvin
I have php 4.1.2 running on a linux 7.2 box. I want to make a connection to an Informix 7.2SE database running on a HP-UX 10.2 box. My issues are as follows - 1) Do I need informix software of any description running on the linux web server? 2) Can I configure the php informix modules into and up

[PHP] DATE_FORMAT (MySQL function)

2002-10-03 Thread Mark Colvin
I'm not sure if this is a php or mysql issue but I run the following query from a php script - $query = select d1.code, d1.type, d1.descr, d1.grouptype, d1.cusref, d1.stock, d1.minstock, d1.appmeth, d1.supplier, d1.suppref, d1.leadtime, d1.price, d1.reorder, d1.code1, d1.code2, d1.notes, d1.usr,

[PHP] Image Problem

2002-10-08 Thread Mark Colvin
I have just upgraded php from 4.0.6 to 4.2.3. Everything works OK apart from the line below - echo 'td colspan=2 rowspan=2 align=centerimg alt=No Image to display. src=thumbnail.php?image=00042.jpg valign=top//td'; The thumbnail.php script uses php functions imagecreate, imagecreatefromjpeg,