PHP MYSQL Query Problem?
- b_heyer
- Web Master
- Joined: Jun 15, 2003
- Posts: 4583
- Loc: Maryland
- Status: Offline
July 10th, 2003, 1:01 pm
I seem to have a problem that I can't quite pin down, maybe a fresh pair of eyes will spot it for me 
The problem I think is somewhere in here:
because the image that is supposed to be displayed after it, isn't displayed, nor is the text. I do not recieve any errors when viewing the page, it is just acting similarly to when you try viewing and html page where you left a ">" off.
Code: [ Select ]
$newmin = $min_math[0]*$days*1440 + $min_math[1]*1440 + $min_math[2]*60 + $min_math[3];
$newapp = $newrow[appearances] + 1;
$noexist = 0;
mysql_query("UPDATE `signature` SET `isnow` = '0' AND `appearances` = '" . $newapp . "' AND `minutes` = '" . $newmin . "' WHERE `filename` = '" . $newrow[filename] . "'") OR
DIE (mysql_error());
$fin_sql = mysql_query("SELECT * FROM signature WHERE filename = " . $finalize) OR
DIE (mysql_error());
$finrow = mysql_fetch_array ($fin_sql);
mysql_query("REPLACE INTO signature (filename, isnow, date, minutes, appearances) VALUES (" . $finalize .", 1, " . $findate . ", " . $finrow[minutes] . ", " . $finrow[appearances] . ")") OR
DIE (mysql_error());
mysql_free_result($fin_sql);
copy ($finalize . '.jpg' , 'now.jpg');
echo ("<br><br><br><img src='now.jpg' alt='New Signature'>");
echo ("<br><br>The New Signature");
$newapp = $newrow[appearances] + 1;
$noexist = 0;
mysql_query("UPDATE `signature` SET `isnow` = '0' AND `appearances` = '" . $newapp . "' AND `minutes` = '" . $newmin . "' WHERE `filename` = '" . $newrow[filename] . "'") OR
DIE (mysql_error());
$fin_sql = mysql_query("SELECT * FROM signature WHERE filename = " . $finalize) OR
DIE (mysql_error());
$finrow = mysql_fetch_array ($fin_sql);
mysql_query("REPLACE INTO signature (filename, isnow, date, minutes, appearances) VALUES (" . $finalize .", 1, " . $findate . ", " . $finrow[minutes] . ", " . $finrow[appearances] . ")") OR
DIE (mysql_error());
mysql_free_result($fin_sql);
copy ($finalize . '.jpg' , 'now.jpg');
echo ("<br><br><br><img src='now.jpg' alt='New Signature'>");
echo ("<br><br>The New Signature");
- $newmin = $min_math[0]*$days*1440 + $min_math[1]*1440 + $min_math[2]*60 + $min_math[3];
- $newapp = $newrow[appearances] + 1;
- $noexist = 0;
- mysql_query("UPDATE `signature` SET `isnow` = '0' AND `appearances` = '" . $newapp . "' AND `minutes` = '" . $newmin . "' WHERE `filename` = '" . $newrow[filename] . "'") OR
- DIE (mysql_error());
- $fin_sql = mysql_query("SELECT * FROM signature WHERE filename = " . $finalize) OR
- DIE (mysql_error());
- $finrow = mysql_fetch_array ($fin_sql);
- mysql_query("REPLACE INTO signature (filename, isnow, date, minutes, appearances) VALUES (" . $finalize .", 1, " . $findate . ", " . $finrow[minutes] . ", " . $finrow[appearances] . ")") OR
- DIE (mysql_error());
- mysql_free_result($fin_sql);
- copy ($finalize . '.jpg' , 'now.jpg');
- echo ("<br><br><br><img src='now.jpg' alt='New Signature'>");
- echo ("<br><br>The New Signature");
The problem I think is somewhere in here:
Code: [ Select ]
mysql_query("REPLACE INTO signature (filename, isnow, date, minutes, appearances) VALUES (" . $finalize .", 1, " . $findate . ", " . $finrow[minutes] . ", " . $finrow[appearances] . ")") OR
DIE (mysql_error());
DIE (mysql_error());
- mysql_query("REPLACE INTO signature (filename, isnow, date, minutes, appearances) VALUES (" . $finalize .", 1, " . $findate . ", " . $finrow[minutes] . ", " . $finrow[appearances] . ")") OR
- DIE (mysql_error());
because the image that is supposed to be displayed after it, isn't displayed, nor is the text. I do not recieve any errors when viewing the page, it is just acting similarly to when you try viewing and html page where you left a ">" off.
Pixel Acres V2
- Anonymous
- Bot
- Joined: 25 Feb 2008
- Posts: ?
- Loc: Ozzuland
- Status: Online
July 10th, 2003, 1:01 pm
- guitrspaz
- Graduate
- Joined: Apr 27, 2003
- Posts: 106
- Loc: Baltimore, MD
- Status: Offline
July 11th, 2003, 10:44 pm
- b_heyer
- Web Master
- Joined: Jun 15, 2003
- Posts: 4583
- Loc: Maryland
- Status: Offline
July 13th, 2003, 10:32 am
hrmmm thought I deleted it, thanks for looking tho, it works fine now. 
Pixel Acres V2
Page 1 of 1
To Reply to this topic you need to LOGIN or REGISTER. It is free.
Post Information
- Total Posts in this topic: 3 posts
- Users browsing this forum: Kurthead+1 and 113 guests
- You cannot post new topics in this forum
- You cannot reply to topics in this forum
- You cannot edit your posts in this forum
- You cannot delete your posts in this forum
- You cannot post attachments in this forum
