Justtechjobs.com Find a programming school near you






Online Campus Both


php-general | 2000071

Re: Re: [PHP] Troubled code (or my troubled brain) From: Tyler Longren (tyler.longren <email protected>)
Date: 07/02/00

Thank you very much to everybody that responded to my question. My problem
has now been fixed.

I've got one more question though, is there any way to format
show_source("something.txt"); ?
It doesn't like to adjust to the size of tables, it just expands the tables
and then it screws the whole page up if there's a long line in it.

Thanks once again!!

On Sun, 2 Jul 2000, Jay Greenspan wrote:
> Date: Sun, 2 Jul 2000 12:16:49 -0700
> To: <tyler.longren <email protected>>
> From: "Jay Greenspan" <jay <email protected>>
> Subject: Re: [PHP] Troubled code (or my troubled brain)
>
> Start by removing the quotes around the variable.
> if ($id == $name) is more like it.
>
> this is also pretty weird:
>
> $result = mysql_query ("SELECT * FROM user_code WHERE language LIKE
> 'php'");
>
> use LIKE with wildcards, for instance
> select .... where language like 'php%'
>
> otherwise..
>
> select ... where language = 'php'
>
> -j
>
> >if ($id == "$name") {
> >echo "$count";
> >}
> >else {
> >echo "0";
> >}
> >
> >No matter what, this is always 0.
> >
> >I think that I have something wrong somewhere else in my code however
> and
> >I don't know where it's at. So here's the rest of it (don't make fun of
> >the dirtiness):
> >
> ><?
> >echo "<Center><u><b>PHP Code</u></b></center><Br>";
> >$connection = mysql_connect("host", "user", "pass") or die ("Unable to
> >connect to server.");
> >$db = mysql_select_db("cr0n", $connection) or die ("Unable to find
> >requested database.");
> >$result = mysql_query ("SELECT * FROM user_code WHERE language LIKE
> >'php'");
> >$numrows = mysql_num_rows($result);
> >while($row = mysql_fetch_array($result)) {
> >$description = $row["description"];
> >$email = $row["email"];
> >$type = $row["type"];
> >$id = $row["id"];
> >$language = $row["language"];
> >$author = $row["name"];
> >$date = $row["date"];
> >$result2 = mysql_query("SELECT * FROM counter WHERE name = '$id''");
> >while($row2 = mysql_fetch_array($result2)) {
> >$count = $row2["count"];
> >$name = $row2["name"];
> >}
> >echo "<table width=75% align=center bgcolor=#000000 cellpadding=0
> >cellspacing=0><tr><td bgcolor=#000000><table width=100% border=0
> >cellspacing=1 cellpadding=1 height=0%>
> > <tr>
> > <td height=15 bgcolor=#000000 colspan=2><A
> >href=\"viewcode.php?id=$id\"><font size=-1 color=#FFFFFF face=Arial,
> >Helvetica, sans-serif>$description</font></a></td>
> > </tr>
> > <tr>
> > <td bgcolor=#4A5A63 valign=top width=50% height=23>Author: <a
> >href=\"mailto:$email\"><font size=-1 color=#000000 face=Arial,
> Helvetica,
> >sans-serif>$author</font></a></td>
> > <td bgcolor=#4A5A63 valign=top width=50% height=23>Date: $date</td>
> > </tr>
> > <tr>
> > <td bgcolor=#4A5A63 valign=top width=50% height=24>Category:
> $type</td>
> > <td bgcolor=#4A5A63 valign=top width=50% height=24>Views: ";
> >
> >//here's the troubled section
> >if ($id == "$name") {
> >echo "$count";
> >}
> >else {
> >echo "0";
> >}
> >echo "</td></tr></table></td></tr></table><Br>";
> >
> >}
> >if ($numrows == "0") {
> >echo "<center><font color=#000000 size=2 face=Arial, Helvetica,
> >sans-serif>No PHP code has been submitted yet!</font></center>";
> >}
> >
> >mysql_free_result($result);
> >?>
> >
> >If anybody has any idead, please let me know, this is really bothering
> me.
> >
> >Regards,
> >Tyler
> >
> >--
> >PHP General Mailing List (http://www.php.net/)
> >To unsubscribe, e-mail: php-general-unsubscribe <email protected>
> >For additional commands, e-mail: php-general-help <email protected>
> >To contact the list administrators, e-mail: php-list-admin <email protected>
> >
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>